Re: [GENERAL] Concatenating two Text fields from the same tuple

2003-07-03 Thread Andrew Sullivan
On Thu, Jul 03, 2003 at 06:16:35PM +0100, [EMAIL PROTECTED] wrote: > Question 2: If not - is it possible for me to concatenate attr1 and > attr2 before i do the search as this would remove the logic problems. ( > and if it is possible - is it efficient?) I don't know the answer to your other pro

[GENERAL] Concatenating two Text fields from the same tuple

2003-07-03 Thread psql-mail
Apologies if this is a repost - I tried sending it yesterday and haven' t seen it in the forum yet. I am currently writing a perl script to convert the string a user supplies to a search engine into SQL. The user supplies a string in the same foramt as google uses - e.g. "cat -dog" finds records