pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Dave Page <dpage@vale-housing.co.uk>
To: inoue@tpf.co.jp
Cc: dpage@vale-housing.co.uk
Cc: tgl@sss.pgh.pa.us
Cc: ZeugswetterA@spardat.at
Cc: pgman@candle.pha.pa.us
Cc: pgsql-hackers@postgresql.org
Cc: pgsql-interfaces@postgresql.org
Subject: Re: Roadmap for FE/BE protocol redesign
Date: Fri, 14 Mar 2003 08:47:03 -0000 (GMT)
Message-ID: <50177.80.177.99.193.1047631623.squirrel@ssl.vale-housing.co.uk> (raw)
In-Reply-To: <002f01c2e9aa$02e13160$0e283ddb@PbgX>
References: <03AF4E498C591348A42FC93DEA9661B8259DA3@mail.vale-housing.co.uk>
	<002f01c2e9aa$02e13160$0e283ddb@PbgX>

It's rumoured that Hiroshi Inoue once said:
>> -----Original Message-----
>> From: Dave Page
>>
>> > -----Original Message-----
>> > From: Hiroshi Inoue [mailto:Inoue@tpf.co.jp]
>> > Sent: 13 March 2003 10:04
>> > To: Dave Page
>> > Cc: tgl@sss.pgh.pa.us; ZeugswetterA@spardat.at;
>> > pgman@candle.pha.pa.us; pgsql-hackers@postgresql.org;
>> > pgsql-interfaces@postgresql.org
>> > Subject: Re: [HACKERS] Roadmap for FE/BE protocol redesign
>> >
>> >
>> > Dave Page wrote:
>> > >
>> > > It's rumoured that Hiroshi Inoue once said:
>> > > >
>> > > > Does looking up by the catalog keys take no cost ?
>> > >
>> > > Obviously there is cost, but doing a lookup only on demand,
>> > has got to
>> > > be cheaper in the long run than including the entire column
>> > definition
>> > > in the message whether it's wanted or not?
>> >
>> > So if there are 100 fields, should we ask the backend
>> > the column name 100 times ?
>>
>> No, the column name is there already.
>
> The column name isn't there. If a field has its alias name the alias is
> there.

Ahh yes, you're right of course. The docs are a little sketchy on that
detail
(http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=protocol-message-formats.htm...).
Regards, Dave





view thread (133+ messages)  latest in thread

Message-ID: <50177.80.177.99.193.1047631623.squirrel@ssl.vale-housing.co.uk>
Permalink:  ../50177.80.177.99.193.1047631623.squirrel@ssl.vale-housing.co.uk/
Also on:    postgresql.org/message-id/50177.80.177.99.193.1047631623.squirrel@ssl.vale-housing.co.uk

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: dpage@vale-housing.co.uk, inoue@tpf.co.jp, tgl@sss.pgh.pa.us, ZeugswetterA@spardat.at, pgman@candle.pha.pa.us, pgsql-hackers@postgresql.org
  Subject: Re: Roadmap for FE/BE protocol redesign
  In-Reply-To: <50177.80.177.99.193.1047631623.squirrel@ssl.vale-housing.co.uk>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox