From: Markus Bertheau <mbertheau.pg@googlemail.com>
To: Jaime Casanova <systemguards@gmail.com>
Cc: Franklin Haut <franklin.haut@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Cast in PG 8.3
Date: Wed, 6 Feb 2008 02:12:18 +0600
Message-ID: <684362e10802051212m7dacf641xaf7a36a5154b2a1d@mail.gmail.com> (raw)
In-Reply-To: <c2d9e70e0802051118h7f9fe0f7q6c7dcd1a45fb7a82@mail.gmail.com>
References: <47A8B788.6010304@gmail.com>
<c2d9e70e0802051118h7f9fe0f7q6c7dcd1a45fb7a82@mail.gmail.com>
2008/2/6, Jaime Casanova <systemguards@gmail.com>:
> did you read the release notes?
Obviously he did:
> I Know that changing the SQL command to :
> SELECT * FROM TEMP WHERE CAST(id AS TEXT) ilike ('%122%');
> work´s but for now isn't possible... :(
>
>
> I Tries create a cast but the function text doesn't exist more in PG 8.3
>
> CREATE CAST (int AS text) WITH FUNCTION text(int);
>
> can everyone help me to create a cast ou other solution ?
So the question stands.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mbertheau.pg@googlemail.com, systemguards@gmail.com, franklin.haut@gmail.com
Subject: Re: Cast in PG 8.3
In-Reply-To: <684362e10802051212m7dacf641xaf7a36a5154b2a1d@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox