Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 6A57C635CBE for ; Thu, 11 Jun 2009 06:00:57 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 15507-05 for ; Thu, 11 Jun 2009 06:00:56 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-gx0-f207.google.com (mail-gx0-f207.google.com [209.85.217.207]) by mail.postgresql.org (Postfix) with ESMTP id 411EF635C5E for ; Thu, 11 Jun 2009 06:00:56 -0300 (ADT) Received: by gxk3 with SMTP id 3so1981912gxk.19 for ; Thu, 11 Jun 2009 02:00:55 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type :content-transfer-encoding; bh=AVIuRgdolukllDQ1KfmuQ4LYBBUOpEjPw5t7aMx+Ctg=; b=EMr6O7p+hH7fWCN8DCSu2SKkl0G0Vw5kTemGP6FZHYyfWCS6mk3+ay8vZG/YDCoZtO q1MH8tnyAtmhhwvqsIUNMSsO20B9mqBJ1CdGVm312+jrduJRIBW+dvxZQzKJdy8foIkE oVYhcYTSdExOGsi0FxQR3OnA8FjV48K+V/vNQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type:content-transfer-encoding; b=oC2HY4/qZOTvjjE7aKNYU9YJlsdoA+nFanUp31XLL/CbpZqGh6B8WPp5LJBZDHLmYA 5OMLWlO6oqTQuNhcE835fuwpThAixq4v5I34p0wm6sNkt4S9mb+6heztvitHtmIPcL4+ Q40XNxKqcxth06PU/JtpLBZdWMp+Mopw/82/Y= MIME-Version: 1.0 Received: by 10.151.137.8 with SMTP id p8mr4712416ybn.56.1244710479151; Thu, 11 Jun 2009 01:54:39 -0700 (PDT) In-Reply-To: <000001c9ea68$217cb890$647629b0$@com> References: <200906100519.34171.jfabiani@yolo.com> <000001c9ea68$217cb890$647629b0$@com> Date: Thu, 11 Jun 2009 10:54:39 +0200 Message-ID: <162867790906110154t7e555899h5fbc006266f7e708@mail.gmail.com> Subject: Re: dynamic columns in a query From: Pavel Stehule To: Jyoti Seth Cc: pgsql-sql@postgresql.org Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: base64 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200906/53 X-Sequence-Number: 32658 SGVsbG8KCjIwMDkvNi8xMSBKeW90aSBTZXRoIDxqeW90aXNldGgyMDAxQGdtYWlsLmNvbT46Cj4g SGkgQWxsLAo+Cj4gSXMgdGhlcmUgYW55IHdheSBpbiBwb3N0Z3JlcyB0byB3cml0ZSBhIHF1ZXJ5 IHRvIGRpc3BsYXkgdGhlIHJlc3VsdCBpbgo+IG1hdHJpeCBmb3JtLiAod2hlcmUgY29sdW1uIG5h bWVzIGFyZSBkeW5hbWljKQo+Cgpsb29rIG9uIGh0dHA6Ly9va2JvYi5ibG9nc3BvdC5jb20vMjAw OC8wOC91c2luZy1jdXJzb3JzLWZvci1nZW5lcmF0aW5nLWNyb3NzLmh0bWwKCnJlZ2FyZHMKUGF2 ZWwgU3RlaHVsZQoKPiBGb3IgZWcuCj4KPgo+IEVtcGxveWVlIE5hbWUgwqAgQ2xpZW50MSBDbGll bnQyIENsaWVudDMgQ2xpZW50NAo+IEVtcDEgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAx MDAgwqAgwqAgwqAgwqAgwqAgwqAgMTAyIMKgIMKgIMKgIMKgIMKgIMKgIDkwIMKgIMKgIMKgIMKg IMKgIMKgIMKgMjMKPiBFbXAyIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgNTYgwqAgwqAg wqAgwqAgwqAgwqAgwqAwIMKgIMKgIMKgIMKgIMKgIMKgIMKgIDIzIMKgIMKgIMKgIMKgIMKgIMKg IMKgOTgKPiBFbXAzIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgMzQgwqAgwqAgwqAgwqAg wqAgwqAgwqA0NSDCoCDCoCDCoCDCoCDCoCDCoCDCoDc2IMKgIMKgIMKgIMKgIMKgIMKgIMKgMAo+ Cj4KPiBIZXJlIENsaWVudDEsIENsaWVudDIuLi4gYXJlIHRoZSB2YWx1ZXMgZnJvbSB0aGUgZGF0 YWJhc2UuCj4KPiBUaGFua3MsCj4gSnlvdGkKPgo+Cj4KPiAtLQo+IFNlbnQgdmlhIHBnc3FsLXNx bCBtYWlsaW5nIGxpc3QgKHBnc3FsLXNxbEBwb3N0Z3Jlc3FsLm9yZykKPiBUbyBtYWtlIGNoYW5n ZXMgdG8geW91ciBzdWJzY3JpcHRpb246Cj4gaHR0cDovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9tYWls cHJlZi9wZ3NxbC1zcWwKPgo=