Postgres Pro
Downloads
Home   >   mailing lists

Re: column "id" is of type integer but expression is of type character - Mailing list pgsql-general

From Tom Lane
Subject Re: column "id" is of type integer but expression is of type character
Date
Msg-id 20091.1231442290@sss.pgh.pa.us
Whole thread Raw
In response to Re: column "id" is of type integer but expression is of type character  (Raymond O'Donnell <rod@iol.ie>)
List pgsql-general
Tree view 
"Raymond O'Donnell" <rod@iol.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

pgsql-general by date:

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