I'm fairly new to generating my own reports (and to SQL in general), so
I may be missing something obvious, but is the LIKE syntax supported
for reports? I can't seem to get it to work. We are using postgres as
the Track DB.

The following query works:
SELECT id AS ticket, summary, component
  FROM ticket t
  WHERE component IN ('cuemkvid')


But this one with a LIKE does not:
SELECT id AS ticket, summary, component
  FROM ticket t
  WHERE component LIKE '%'

Any help would be greatly appreciated. Thanks!


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac 
Users" group.
To post to this group, send email to trac-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/trac-users
-~----------~----~----~----~------~----~------~--~---

Reply via email to