Re: [HACKERS] Opening a plpgsql cursor parameter by name

2010-09-22 Thread Yeb Havinga
Tom Lane wrote: Yeb Havinga writes: We intend to implement $subject, so instead of mycursor CURSOR (myparm text) IS SELECT myparm; OPEN mycursor('A'); it would be possible to do OPEN mycursor(myparm := 'A'); Is this really worth the trouble? Is it supported by any other DBMS? Are c

Re: [HACKERS] Opening a plpgsql cursor parameter by name

2010-09-22 Thread Tom Lane
Yeb Havinga writes: > We intend to implement $subject, so instead of > mycursor CURSOR (myparm text) IS SELECT myparm; > OPEN mycursor('A'); > it would be possible to do > OPEN mycursor(myparm := 'A'); Is this really worth the trouble? Is it supported by any other DBMS? Are cursors used so mu

[HACKERS] Opening a plpgsql cursor parameter by name

2010-09-22 Thread Yeb Havinga
Hello list, We intend to implement $subject, so instead of mycursor CURSOR (myparm text) IS SELECT myparm; OPEN mycursor('A'); it would be possible to do OPEN mycursor(myparm := 'A'); The idea is to * in pl_exec.exec_stmt_forc, detect if a positional parameter or named parameter is used. *