[SQL]

    hi every body, how to return the resultset from the function

[SQL] strange quoted csv behavior with COPY

what would you expect the following command to insert into column a: copy foo (a,b) from stdin with csv; "bar" , 3 \. i was expecting to see 'bar', but instead i get 'bar ' (the spaces between the double quote and the comma get inserted. select length(a), * from foo; length | a| b --

Re: [SQL] Does PostgreSQL support job?

O Markus Schaber έγραψε στις Feb 2, 2006 : > H, Achilleus, > > Achilleus Mantzios wrote: > > >>PLPGSQL is turing complete, plain SQL is not. > > H is SQL equally powerful as a pushdown automaton then??? > > SQL is _not_ a programming language, it is a query language. It is not > meant to be

Re: [SQL] Does PostgreSQL support job?

H, Achilleus, Achilleus Mantzios wrote: >>PLPGSQL is turing complete, plain SQL is not. > H is SQL equally powerful as a pushdown automaton then??? SQL is _not_ a programming language, it is a query language. It is not meant to be turing complete. Just as e. G. HTML, CSS or RFC2822 are stru

Re: [SQL] Does PostgreSQL support job?

O Markus Schaber έγραψε στις Feb 2, 2006 : > Hi, Daniel, > > Daniel Caune wrote: > > > I'm not sure to understand. Why calling a function from a script is > > different from executing a series of SQL commands? I mean, I can run a > > script defined as follows: > > > > SELECT myjob(); > > >

Re: [SQL] Does PostgreSQL support job?

> Daniel Caune wrote: > >>> I'm not sure to understand. Why calling a function from a script is > >>> different from executing a series of SQL commands? > > [snip] > >>>Does that make sense? > >>It does make sense if myjob() does more than just execute a bunch of > >>statements, e. G. it contains

Re: [SQL] Does PostgreSQL support job?

Hi, Daniel, Daniel Caune wrote: >>> I'm not sure to understand. Why calling a function from a script is >>> different from executing a series of SQL commands? [snip] >>>Does that make sense? >>It does make sense if myjob() does more than just execute a bunch of >>statements, e. G. it contains i

Re: [SQL] Does PostgreSQL support job?

> > I'm not sure to understand. Why calling a function from a script is > different from executing a series of SQL commands? I mean, I can run a > script defined as follows: > > > > SELECT myjob(); > > > > where myjob is a stored procedure such as: > > > > CREATE OR REPLACE FUNCTION myjob() > >

Re: [SQL] Changing the transaction isolation level within the stored

Hi, Andreq, Andrew Sullivan wrote: > I think you don't have a clear idea of what locks are necessary for > updates. Write operations on a row must block other write operations > on the same row. If more than one transaction needs the same kinds > of locks on two different tables, but attempts t

Re: [SQL] Does PostgreSQL support job?

Hi, Daniel, Daniel Caune wrote: > I'm not sure to understand. Why calling a function from a script is > different from executing a series of SQL commands? I mean, I can run a > script defined as follows: > > SELECT myjob(); > > where myjob is a stored procedure such as: > > CREATE OR REPLA

Re: [SQL] executing dynamic commands

Thanx a lot guys - it works ! Cheers Chris On Wed, 1 Feb 2006 christian ( dot ) michels ( at ) eifelgeist ( dot ) com wrote: > Hi, > > I user PostgreSQl 8.0.4 on Win2003 Server and write a function to copy rows > from one table into another table with the same column definition. > My first

Re: [SQL] Does PostgreSQL support job?

> > > I try to find in the documentation whether PostgreSQL > supports job, > > > but I miserably failed. Does PostgreSQL support job? If > not, what > > > is the mechanism mostly adopted by PostgreSQL administrators for > > > running jobs against PostgreSQL? I was thinking about using > >