[SQL] Run Function With First Priority

2007-11-20 Thread Otniel Michael
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

[SQL] Loading 8.2 data into 8.1

2007-11-20 Thread Andreas Joseph Krogh
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

[SQL] dynmic column names inside trigger?

2007-11-20 Thread Louis-David Mitterrand
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

Re: [SQL] dynmic column names inside trigger?

2007-11-20 Thread Tom Lane
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

Re: [SQL] [ODBC] string function

2007-11-20 Thread Phillip Smith
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.