pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedFwd: Casting issue!!
4+ messages / 4 participants
[nested] [flat]
* Fwd: Casting issue!!
@ 2009-01-07 13:58 jose fuenmayor <jafn82@gmail.com>
2009-01-07 14:01 ` Re: Fwd: Casting issue!! Matthew Wakeling <matthew@flymine.org>
2009-01-07 14:07 ` Re: Fwd: Casting issue!! tv@fuzzy.cz
2009-01-07 15:16 ` Re: Fwd: Casting issue!! Glyn Astill <glynastill@yahoo.co.uk>
0 siblings, 3 replies; 4+ messages in thread
From: jose fuenmayor @ 2009-01-07 13:58 UTC (permalink / raw)
To: tgl@sss.pgh.pa.us; pgsql-performance
---------- Forwarded message ----------
From: jose fuenmayor <jafn82@gmail.com>
Date: Wed, Jan 7, 2009 at 2:56 PM
Subject: Casting issue!!
To: psql-admin@postgresql.org
Hi all I am trying to migrate from postgresql 8.2.x to 8.3.x, i have an
issue with casting values when i try to perform the auto cast , it does not
work and I get an error, how can i perform auto casting on 8.3 without
rewrite my source code, I am using pl/pgsql. I mean i dont want to write
value::dataType. I dont want to use explicit type cast. Maybe change
something in the config files? to make it work like 8.2 on tha regard(cast
values).
thanks a lot!!!
Kind Regards;
Jose Fuenmayor
ç
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Fwd: Casting issue!!
2009-01-07 13:58 Fwd: Casting issue!! jose fuenmayor <jafn82@gmail.com>
@ 2009-01-07 14:01 ` Matthew Wakeling <matthew@flymine.org>
2 siblings, 0 replies; 4+ messages in thread
From: Matthew Wakeling @ 2009-01-07 14:01 UTC (permalink / raw)
To: jose fuenmayor <jafn82@gmail.com>; +Cc: pgsql-performance
On Wed, 7 Jan 2009, jose fuenmayor wrote:
> Hi all I am trying to migrate from postgresql 8.2.x to 8.3.x, i have an issue with casting values when i try to
> perform the auto cast , it does not work and I get an error, how can i perform auto casting on 8.3 without
> rewrite my source code, I am using pl/pgsql. I mean i dont want to write value::dataType. I dont want to use
> explicit type cast. Maybe change something in the config files? to make it work like 8.2 on tha regard(cast
> values).
What does that have to do with performance?
Matthew
--
Illiteracy - I don't know the meaning of the word!
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Fwd: Casting issue!!
2009-01-07 13:58 Fwd: Casting issue!! jose fuenmayor <jafn82@gmail.com>
@ 2009-01-07 14:07 ` tv@fuzzy.cz
2 siblings, 0 replies; 4+ messages in thread
From: tv@fuzzy.cz @ 2009-01-07 14:07 UTC (permalink / raw)
To: jose fuenmayor <jafn82@gmail.com>; +Cc: tgl@sss.pgh.pa.us; pgsql-performance
Hi Jose,
why haven't you post an example of the failing query, data and the exact
error message? The casting should work on 8.3 (and it works for me) so I
guess there are some invalid data, invalid SQL or something like that.
Anyway I doubt this is a performance issue - this falls into generic SQL
mailing list.
regards
Tomas
> ---------- Forwarded message ----------
> From: jose fuenmayor <jafn82@gmail.com>
> Date: Wed, Jan 7, 2009 at 2:56 PM
> Subject: Casting issue!!
> To: psql-admin@postgresql.org
>
>
> Hi all I am trying to migrate from postgresql 8.2.x to 8.3.x, i have an
> issue with casting values when i try to perform the auto cast , it does
> not
> work and I get an error, how can i perform auto casting on 8.3 without
> rewrite my source code, I am using pl/pgsql. I mean i dont want to write
> value::dataType. I dont want to use explicit type cast. Maybe change
> something in the config files? to make it work like 8.2 on tha regard(cast
> values).
> thanks a lot!!!
> Kind Regards;
> Jose Fuenmayor
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> ç
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Fwd: Casting issue!!
2009-01-07 13:58 Fwd: Casting issue!! jose fuenmayor <jafn82@gmail.com>
@ 2009-01-07 15:16 ` Glyn Astill <glynastill@yahoo.co.uk>
2 siblings, 0 replies; 4+ messages in thread
From: Glyn Astill @ 2009-01-07 15:16 UTC (permalink / raw)
To: tgl@sss.pgh.pa.us, pgsql-performance@postgresql.org, jose fuenmayor <jafn82@gmail.com>
--- On Wed, 7/1/09, jose fuenmayor <jafn82@gmail.com> wrote:
>
> Hi all I am trying to migrate from postgresql 8.2.x to
> 8.3.x, i have an
> issue with casting values when i try to perform the auto
> cast , it does not
> work and I get an error, how can i perform auto casting on
> 8.3 without
> rewrite my source code, I am using pl/pgsql. I mean i dont
> want to write
> value::dataType. I dont want to use explicit type cast.
> Maybe change
> something in the config files? to make it work like 8.2 on
> tha regard(cast
> values).
> thanks a lot!!!
> Kind Regards;
> Jose Fuenmayor
As the others have said; you'd be better off posting this in the pgsql-general list.
However I think you could proabably work your way around this with a function and a cast, as described here:
http://www.depesz.com/index.php/2008/05/05/error-operator-does-not-exist-integer-text-how-to-fix-it/
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2009-01-07 15:16 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-01-07 13:58 Fwd: Casting issue!! jose fuenmayor <jafn82@gmail.com>
2009-01-07 14:01 ` Matthew Wakeling <matthew@flymine.org>
2009-01-07 14:07 ` tv@fuzzy.cz
2009-01-07 15:16 ` Glyn Astill <glynastill@yahoo.co.uk>
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