[GENERAL] JDBC: what exactly does nullsAreSortedHigh() return?

2004-06-06 Thread Vikas Rana
Hi all, I am a bit confused about the method java.sql.DatabaseMetaData.nullsAreSortedHigh(). What exactly does this return? If this returns true, are nulls considered as the highest value? Or does this mean that nulls comes first when sorted in ascending order (opposite in meaning to the first).

Re: [GENERAL] statement level triggers in PostgreSQL , anybody??

2004-06-06 Thread Vikas Rana
> This has nothing to do with triggers, it has to do with not being able > to defer UNIQUE constraints. The classic solution is: > > update SET column = -column; > update SET column = -column+1; Thanks for the reply. Is changing query the only way to do this in postgres? I would expect some mor