X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 83E32476262 for ; Tue, 6 May 2003 05:53:43 -0400 (EDT) Received: from shield.nordlb.lv (shield.pirmabanka.lv [195.114.57.4]) by postgresql.org (Postfix) with ESMTP id 235F6474E42 for ; Tue, 6 May 2003 05:53:42 -0400 (EDT) Received: from wall2.pirmabanka.lv (wall2-pub.nordlb.lv [195.114.57.14]) by shield.nordlb.lv (8.12.9/8.12.9) with SMTP id h469rhbg024094 for ; Tue, 6 May 2003 12:53:43 +0300 Received: from share.nordlb.lv ([10.0.0.10]) by wall2.pirmabanka.lv; Tue, 06 May 2003 12:53:42 +0300 (EET DST) Received: from pc311x1.nordlb.lv (localhost.localdomain [127.0.0.1]) by nordlb.lv (8.11.6/8.11.6) with SMTP id h469rgC07626 for ; Tue, 6 May 2003 12:53:42 +0300 Received: (qmail 17741 invoked by uid 100); 6 May 2003 09:55:50 -0000 Date: Tue, 6 May 2003 12:55:50 +0300 From: "Victor Yegorov" To: Rado Petrik Cc: PostgreSQL-mailinglist Subject: Re: Problem with Attribute. Message-ID: <20030506095550.GI16791@nordlb.lv> Mail-Followup-To: Rado Petrik , PostgreSQL-mailinglist References: <1052212666.551.29.camel@caj> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="y2zxS2PfCDLh6JVG" Content-Disposition: inline In-Reply-To: <1052212666.551.29.camel@caj> User-Agent: Mutt/1.4.1i X-Spam-Status: No, hits=-28.1 required=5.0 tests=BAYES_10,IN_REP_TO,PGP_SIGNATURE_2,REFERENCES, USER_AGENT_MUTT autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200305/75 X-Sequence-Number: 13240 --y2zxS2PfCDLh6JVG Content-Type: text/plain; charset=koi8-r Content-Disposition: inline Content-Transfer-Encoding: quoted-printable * Rado Petrik [06.05.2003 12:54]: > power2=3D# select count from picture_path; >=20 > return:=20 >=20 > ERROR: Attribute 'count' not found > power2=3D#=20 >=20 > Why ?=20 count() is a function. so: select count(*) from picture_path; --=20 Victor Yegorov --y2zxS2PfCDLh6JVG Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQE+t4am2RKGLEykUDYRAsJMAJ9XpubArxWwMzrjBsEbrEntInZtwQCfTMx1 hHPFtBst/APAmkL8hpq5qxU= =U/Ny -----END PGP SIGNATURE----- --y2zxS2PfCDLh6JVG--