Re: [HACKERS] inquiry

"Jinqiang Han" <[EMAIL PROTECTED]> writes: > hi,Bruce Momjian > I think you are wrong. multiple query in a string, such as ""SELECT;SELECT" > will invoke pg_execute_query_string twice, It won't generate two parsetree. Try it in something other than psql. psql splits such a string into mult

Re: [HACKERS] inquiry

hi,Bruce Momjian I think you are wrong. multiple query in a string, such as ""SELECT;SELECT" will invoke pg_execute_query_string twice, It won't generate two parsetree. === 2003-03-26 10:20:00 您在来信中写道：=== >Jinqiang Han wrote: >> hello, >> >> I have read the source code

[HACKERS] inquiry

hello, I have read the source code of postgres.c. Two strang things I can't understand. Souce code of Postgres.c: .. Foreach(parsetree_list的元素parsetree){ //In what situation here will be many parsetrees？ … (List *)querytree_list = pg_analyze_and_rewrite(parsetree); foreach(querytree_list中

Re: [HACKERS] inquiry about multi-row resultset in functions

??? wrote: > dear hacker, hello. I want to know how to build a function of my own which > returns rows of resultset, not just a row. > Can anybody help me? Thank you in advance. > It is possible, but not very user friendly if you are using PostgreSQL 7.2.x or before. See contrib/dblink/dblink

[HACKERS] inquiry about multi-row resultset in functions

dear hacker, hello. I want to know how to build a function of my own which returns rows of resultset, not just a row. Can anybody help me? Thank you in advance. Jinqiang Han ---(end of broadcast)--- TIP 2: you can get off all lists at once

Re: [HACKERS] inquiry

In 7.3, SHOW returns a query results that can be resturned to jdbc. We are using beta1/2 now, so you can test that from ftp.postgresql.org. --- [ ?GB2312?] wrote: > thank you for your information. > I want to use the imfor

Re: [HACKERS] inquiry

thank you for your information. I want to use the imformation of show or other utilities sql in jdbc interface. generally  resultset is empty when such sql is execute. I want to get the information like psql. How can I do? Thanks again. You should ask this on general, and be mo

[HACKERS] inquiry

Dear Momjian£¬ hello, I want to make the show variable SQL to return  message like pgresult. how can I revise the source code? Any suggestion? I really need you help. Jinqiang Han

[HACKERS] inquiry

Hi,all expert of the postgresql. I want to learn the kernel of postgresql. When I debug it with gdb, I come to a problem that I can't solve. In the BackendStartup() it forks a new child process. I can't trace into the new child process with attach. It say that Operation is not permitte

[HACKERS] Inquiry From Form [pgsql]

does anybody know who i can talk to about a virus/bug scanning engine for postgresql tables/webportal stuff? i would like to start a proof-of-concept thread for this. sounds strange, i know, but chill out, details to come. ---(end of broadcast)--

[HACKERS] inquiry using create function

Hello, I've tried to search some postgresql mailing lists and i haven't found an answer to my problem... I create a function with the setof keyword... create function employee(int) returns setof employee as 'select * from employee where $1 = id' language 'sql'; Instead of returning a tuple,

[HACKERS] inquiry using create function

Hello, This is my first post here. I've tried to search the archive and i haven't found an answer to my problem...here it is... I created a function with the "create function+setof" keywords... create function employee(int) returns setof employee as 'select * from employee where $1 = id' langu

[HACKERS] Inquiry about PostgreSQL (from form)

I'm organising an open source developers meeting (that will be supported by VA Linux) in february and would like some pgsql developers to be present. Would you be so kind as to spread the word? People interested in attending or make a slide presentation can contact me at [EMAIL PROTECTED], regi