All,
Here are a few records from my series, Filename and Duration are field values
> select * from GTIF_FS2GTP_D where "Duration" > 15 limit 5
name: GTIF_FS2GTP_D
time Duration Filename
---- -------- --------
2017-04-11T13:50:04.063Z 15.807 \\\\abc\\abcfiles\\group\\ftp\\CRMurexExport\\MxCR_20170411_13858\.txt
2017-04-11T13:50:04.093Z 16.014 \\\\abc\\abcfiles\\group\\ftp\\CRMurexExport\\MxCR_20170411_13859\.txt
2017-04-11T13:50:04.11Z 16.197 \\\\abc\\abcfiles\\group\\ftp\\CRMurexExport\\MxCR_20170411_13860\.txt
2017-04-11T13:50:20.91Z 15.36 \\\\abc\\abcfiles\\group\\ftp\\CRMurexExport\\MxCR_20170411_13861\.txt
2017-04-11T13:50:20.927Z 15.543 \\\\abc\\abcfiles\\group\\ftp\\CRMurexExport\\MxCR_20170411_13862\.txt
Where I tries to search for a point based on Filename value
> select * from GTIF_FS2GTP_D where "Filename" = '\\\\abc\\abcfiles\\group\\ftp\\CRMurexExport\\MxCR_20170411_13858\.txt'
I got this error
ERR: error parsing query: found \., expected identifier, string, number, bool at line 1, char 124
Please advise,
John