Re: column "id" is of type integer but expression is of type character

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: rod(at)iol(dot)ie
Cc: Andrus <kobruleht2(at)hot(dot)ee>, pgsql-general(at)postgresql(dot)org
Subject: Re: column "id" is of type integer but expression is of type character
Date: 2009-01-08 19:18:10
Message-ID: 20091.1231442290@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Raymond O'Donnell" <rod(at)iol(dot)ie> writes:
> I've no idea, in any case, whether you can expect SELECTing two columns
> into a one-column table to work.

It won't, but the other error happens to be detected first.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Will Rutherdale (rutherw) 2009-01-08 19:30:23 Re: to_tsquery, plainto_... avoiding bad input, injections. Is there a builtin function for this ? Escaping?
Previous Message Richard Huxton 2009-01-08 19:16:22 Re: column "id" is of type integer but expression is of type character