Alban Hertroys schrieb:
another example?:
RAISE NOTICE "error during validation % :",
'ks:"'||ks||'"@"'||loopdate||'"'; (here LoopDate is a DateTime)
Ehm... What's wrong with RAISE NOTICE "error during validation
ks:"%"@"%" :', ks, loopdate; ? (I don't quite understand the purpose
of that
Klint Gore schrieb:
> RAISE NOTICE "error during validation % :",
'ks:"'||ks||'"@"'||loopdate||'"'; (here LoopDate is a DateTime)
You know you can use more than one % in a raise and it will take care
of the data types?
yes i know. the real code looks like this:
S:='another ABG found on ks
another example?:
RAISE NOTICE "error during validation % :", 'ks:"'||ks||'"@"'||
loopdate||'"'; (here LoopDate is a DateTime)
Ehm... What's wrong with RAISE NOTICE "error during validation
ks:"%"@"%" :', ks, loopdate; ? (I don't quite understand the purpose
of that colon at the end, btw)
Daniel Schuchardt wrote:
Tino Wildenhain schrieb:
RETURN extract(year FROM $1)*100+extract(month FROM $1)-1;
was too clean and easy? ;))
Looks like a good oportunity to clean up your code before anything
unexpected happens :-)
Cheers
T.
LOL. Yes I don't like such easy things :-P
> RAISE
Tino Wildenhain schrieb:
RETURN extract(year FROM $1)*100+extract(month FROM $1)-1;
was too clean and easy? ;))
Looks like a good oportunity to clean up your code before anything
unexpected happens :-)
Cheers
T.
LOL. Yes I don't like such easy things :-P
But you see i have a function so
Daniel Schuchardt wrote:
Tino Wildenhain schrieb:
Hi,
Daniel Schuchardt wrote:
...
in 81:
postgres=# SELECT 1::INTEGER||1::INTEGER;
?column?
--
11
(1 row)
*shudder* is this actually a port of an application originally
targeted at M*Sql? ;)
Are you using those columns somewhere with
Tino Wildenhain schrieb:
Hi,
Daniel Schuchardt wrote:
...
in 81:
postgres=# SELECT 1::INTEGER||1::INTEGER;
?column?
--
11
(1 row)
*shudder* is this actually a port of an application originally
targeted at M*Sql? ;)
Are you using those columns somewhere with their real type - as
inte
Hi,
Daniel Schuchardt wrote:
...
in 81:
postgres=# SELECT 1::INTEGER||1::INTEGER;
?column?
--
11
(1 row)
*shudder* is this actually a port of an application originally
targeted at M*Sql? ;)
Are you using those columns somewhere with their real type - as
integer? I mean if you use the
yeah, its clear that an upgrade from 8.1 to 8.3 is impossible for us
without a major relase.
there are to many changes so the whole project has to be rechecked.
another example:
in 83:
postgres=# SELECT 1::INTEGER||1::INTEGER;
ERROR: operator does not exist: integer || integer at character 18
