Hi,
I don't believe the LEFT function exists (at least by default).
Try this instead:
select SUBSTR(kd_aln,LENGTH(kd_aln) - 1, 2) as code from airlin
Also, please don't cross-post. This isn't an ODBC question. You're more
likely to get useful answers posting once to the correct list.
Louis-David Mitterrand <[EMAIL PROTECTED]> writes:
> I'd like to use it on other tables an columns but how can the column
> name be dynamic inside the procedure.
It can't --- plpgsql has no support for that. You could probably make
it work in some of the other PL languages, such as plperl or plt
Hi,
I've got this trigger to clean up text entered in web forms:
CREATE or replace FUNCTION sanitize_text() RETURNS "trigger"
AS $$
declare
begin
if old.story is not null and new.story != old.story
then
Hi.
Is it considered "safe" to use 8.1's pg_dump to dump an 8.2-db and load it
into 8.1?
--
Andreas Joseph Krogh <[EMAIL PROTECTED]>
Senior Software Developer / Manager
+-+
OfficeNet AS| The most difficult thing in t
Dear All,
How i can run function with first priority on postgres?
In my case, when i run function that need a lot of time. Then the other person
run the other function, i think my function run on the below priority of the
other function.
Thanks.
--
"He who is quick to become angry will co
