On Fri, 2006-09-15 at 00:29 +0000, [EMAIL PROTECTED] wrote:
> 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!
>
I just pasted this query directly into my postgres trac database, and it
ran fine (i.e. it returned all tickets). Is this the exact query that
you ran, or is this not the result you expected?
>
> >
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
