Re: 8.3 vs 8.2 sql compatiblity issue

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, Postgres General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: 8.3 vs 8.2 sql compatiblity issue
Date: 2007-11-15 21:59:08
Message-ID: 20071115215908.GF17793@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane wrote:
> Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com> writes:

> > case when cast(a.attnum as text) IN( select array_to_string(conkey,',')
> > from pg_constraint where
>
> Surely that's the worst bit of SQL code I've seen in awhile.

Wow, you really are lucky.

--
Alvaro Herrera http://www.amazon.com/gp/registry/DXLWNGRJD34J
"Java is clearly an example of money oriented programming" (A. Stepanov)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Hart 2007-11-15 22:07:07 automating backups with windows scheduled tasks and pg_dumpall
Previous Message Reg Me Please 2007-11-15 21:34:22 Re: Variable LIMIT and OFFSET in SELECTs