[GENERAL] "RETURN QUERY" mystery

Can anybody give us more detailed explanation about "RETURN QUERY" syntax and usage with possible some non trivial samples. Thanks in advance. ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subsc

[GENERAL] Non-unique values problem after 'add column'

works as well. Why is a new column affecting unique index creation on an already existing one? Is there any workaround for this issue? Thank you, Dima Kagan ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

Re: [GENERAL] 'like' refuses to use an index???

Keith C. Perry wrote: Ahhh, so it is!! So let me ask you this. In order to build an index that would be able to handle something like "lastname like '%erry'", would you need that full text search patch in contrib (tsearch?) or could you do it with an index on a function? I suppose, if this is

[GENERAL] postmaster and logrotate

to do what I want? Thanks! Dima ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

Re: [GENERAL] CREATE TABLE with REFERENCE

the object type in yoru notes table, so that your trigger knows which table to check against)... The worst thing you can do in such situation is - just forget the constraints, and hope that your app will be able to enforce them on its own. It won't. Dima -