Franklin Haut <[EMAIL PROTECTED]> writes:
> I Tries create a cast but the function text doesn't exist more in PG 8.3
sql-createcast.html tells that
"It is normally not necessary to create casts between user-defined
types and the standard string types (text, varchar, and
char(n)). PostgreSQ
Franklin Haut <[EMAIL PROTECTED]> writes:
> Create Table temp (id int4);
> insert into temp values (1215);
> insert into temp values (1216);
> insert into temp values (1217);
> insert into temp values (1218);
> insert into temp values (1219);
> insert into temp values (1220);
> insert into temp val
2008/2/6, Jaime Casanova <[EMAIL PROTECTED]>:
> 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
@postgresql.org
Subject: Re: [SQL] Cast in PG 8.3
On Feb 5, 2008 2:39 PM, Li, Jingfa <[EMAIL PROTECTED]> wrote:
> check the typo -- "ilike"
>
that's not a typo, it's "case insensitive LIKE"
--
regards,
Jaime Casanova
"Programming today is a race
On Feb 5, 2008 2:39 PM, Li, Jingfa <[EMAIL PROTECTED]> wrote:
> check the typo -- "ilike"
>
that's not a typo, it's "case insensitive LIKE"
--
regards,
Jaime Casanova
"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the univers
check the typo -- "ilike"
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jaime Casanova
Sent: Tuesday, February 05, 2008 11:19 AM
To: Franklin Haut
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Cast in PG 8.3
On Feb 5, 2008 2:22 PM, Fra
On Feb 5, 2008 2:22 PM, Franklin Haut <[EMAIL PROTECTED]> wrote:
>
>
> Hi all,
>
> I´m testing the new version of PostgreSQL in windows plataform but i have a
> problem.
>
>
> In PG 8.2
>
> Create Table temp (id int4);
> insert into temp values (1215);
> insert into temp values (1216);
> insert int
Hi all,
I´m testing the new version of PostgreSQL in windows plataform but i
have a problem.
In PG 8.2
Create Table temp (id int4);
insert into temp values (1215);
insert into temp values (1216);
insert into temp values (1217);
insert into temp values (1218);
insert into temp values (1
