| From: | Michael Hirohama <kamesan(at)ricochet(dot)net> |
|---|---|
| To: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>, tgl(at)sss(dot)pgh(dot)pa(dot)us (Tom Lane) |
| Cc: | pgsql-hackers(at)postgreSQL(dot)org, pgsql-interfaces(at)postgreSQL(dot)org |
| Subject: | Re: retrieving varchar size |
| Date: | 1998-04-27 00:55:54 |
| Message-ID: | l03110705b1698217f47d@[204.179.136.2] |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-interfaces |
The historical reason why the POSTGRES backend is required to send multiple
result sets is to support cursors on queries involving type inheritance and
anonymous target lists.
begin
declare c cursor for
select e.oid, e.* from EMP* e
fetch 10 in c
...
To handle the command sequence above, frontend applications would need to
be provided with a new result descriptor when the "fetch 10 in c" crosses a
result set boundary.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Gould | 1998-04-27 01:46:42 | Re: [HACKERS] Re: [INTERFACES] retrieving varchar size |
| Previous Message | Bruce Momjian | 1998-04-26 23:41:33 | Re: [HACKERS] Re: [INTERFACES] retrieving varchar size |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Gould | 1998-04-27 01:46:42 | Re: [HACKERS] Re: [INTERFACES] retrieving varchar size |
| Previous Message | Henk Vergonet | 1998-04-27 00:03:38 | unsubscribe |