Re: Problem with Attribute.

On 6 May 2003, Rado Petrik wrote:

> Hi ,
>
> I have table picture_path.
>
>
> 1. Step one. Write query to psql.
>
>
> power2=# select * from picture_path ;
>
> retur:
>
> id_path | p_path | count
> ---------+--------+--------
> (0 rows)
>
>
> 2. Step two. Write query.
>
> power2=# select count from picture_path;
>
> return:
>
> ERROR: Attribute 'count' not found
> power2=#
>
> Why ?

maybe you need
select "count " from picture_path;

>
>
> This is dump table picture_path.
>
> CREATE TABLE "picture_path" (
> "id_path" int4 DEFAULT nextval('"picture_path_id_path_seq"'::text)
> NOT NULL,
> "p_path" varchar(20) NOT NULL,
> "count " int2 NOT NULL
> );
>
>
> Thanks.
> -
> Rado Petrik <r(dot)p(at)szm(dot)sk>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

--
==================================================================
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
Nikis 4, Glyfada
Athens 16610
Greece
tel: +30-210-8981112
fax: +30-210-8981877
email: achill(at)matrix(dot)gatewaynet(dot)com
mantzios(at)softlab(dot)ece(dot)ntua(dot)gr