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).
Allows
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
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 colon at
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
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
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
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
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
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
