Re: [SQL] How can I get the last element out of GROUP BY sets?

Tom Lane <[EMAIL PROTECTED]> writes: > Robert Creager <[EMAIL PROTECTED]> writes: > > ... one piece of data I need is the last value for each GROUP BY > > period. Alas, I cannot figure out how to do this. > > SELECT DISTINCT ON (rather than GROUP BY) could get this done for you. Or if you need

[SQL] Batch update issue

Hi, my first question is, is pg74jdbc3.2.jar the latest driver for postgresql? If so, does it support batch updates? I ask this because I am using Hibernate, or trying to should I say!, to do EJB stuff to postgresql and when I try to commit() data to a postgresql table i get the following error: '

Re: [SQL] Database diagram

There is a free Perl script which is called something like pgautodoc which creates DIA diagrams from databases. Take a look for it on Freshmeat. - Original Message - From: "Ganesan Kanavathy" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, January 20, 2004 1