Re: [SQL] Problems with a Query between 7.3 and 8.2

2008-06-04 Thread sathiya moorthy
add_missing_from = on Simple, just turn on the above option in postgresql.conf and restart postgres service. On Wed, Jun 4, 2008 at 5:35 PM, Holm Tiffe <[EMAIL PROTECTED]> wrote: > A. Kretschmer wrote: > > > am Wed, dem 04.06.2008, um 12:47:41 +0200 mailte Holm Tiffe folgendes: > > > > >

[SQL] Use of cmin in psql

2006-07-19 Thread sathiya moorthy
hi, what is the use of the cmin system column After inserting if i see this column cmin has the 0 in the ordinary places., If it is in the transaction place ( between BEGIN and END ) where i had deleted and rollbacked that column has the 33397398 somw what large number..-- s

[SQL] Doubt about User-defined function.

2006-07-15 Thread sathiya moorthy
   I have doubt about user-defined function returns value  : *  why function returns( accepts  ) One attribute in the arguments of function/table, Otherwise it returns the whole record of the table. Function accept more than arguments .       *   Why it doesn`t