Обсуждение: Data Types and Their Aliases

On Jul 10, 2006, at 6:24 PM, Garcia, Joshua wrote:

> Where is there a good reference that shows all the data types and
> their aliases?
>
>
>
> For example, the reference would show that float8 is double
> precision and _float8 is an array of double precision data types.

http://www.postgresql.org/docs/8.1/interactive/datatype.html#DATATYPE-
TABLE

Arrays are not included here, but if you need more details you can
look at the pg_type system table.



John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

Ah...ya I know about pg_type and the manual...those are really the best
references for the aliases huh?

Thanks again,
Josh

-----Original Message-----
From: John DeSoi [mailto:desoi@pgedit.com]
Sent: Monday, July 10, 2006 4:56 PM
To: Garcia, Joshua
Cc: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] Data Types and Their Aliases


On Jul 10, 2006, at 6:24 PM, Garcia, Joshua wrote:

> Where is there a good reference that shows all the data types and
> their aliases?
>
>
>
> For example, the reference would show that float8 is double
> precision and _float8 is an array of double precision data types.

http://www.postgresql.org/docs/8.1/interactive/datatype.html#DATATYPE-
TABLE

Arrays are not included here, but if you need more details you can
look at the pg_type system table.



John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

On Jul 10, 2006, at 9:13 PM, Garcia, Joshua wrote:

> Ah...ya I know about pg_type and the manual...those are really the
> best
> references for the aliases huh?

As far as I'm aware. What's wrong with the table? If there is missing
or incomplete information, you can add comments/suggestions to the
documentation page for future improvements.



John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

"Garcia, Joshua" <Joshua.Garcia@xerox.com> writes:
> Ah...ya I know about pg_type and the manual...those are really the best
> references for the aliases huh?

Well, the *authoritative* reference for type names is the pg_type
catalog, and the authoritative reference for aliases is the type name
productions in gram.y ... if you don't trust the manual, use the source
Luke ...

            regards, tom lane

I don't mind looking at the source.  Although I don't know what gram.y
is.  Can someone help me out with what that means?

Also, my boss would like me to bring the references (aliases, oids, type
names, etc.) together in some way.  As the way they are now, they are
scattered among the table, manual and I guess source.  Otherwise, I
wouldn't have bothered to ask any of these questions in the first place.
Thanks, again.

Josh

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Monday, July 10, 2006 8:52 PM
To: Garcia, Joshua
Cc: John DeSoi; pgsql-novice@postgresql.org
Subject: Re: [NOVICE] Data Types and Their Aliases

"Garcia, Joshua" <Joshua.Garcia@xerox.com> writes:
> Ah...ya I know about pg_type and the manual...those are really the
best
> references for the aliases huh?

Well, the *authoritative* reference for type names is the pg_type
catalog, and the authoritative reference for aliases is the type name
productions in gram.y ... if you don't trust the manual, use the source
Luke ...

            regards, tom lane

The table and manual don't really seem missing or incomplete.  However,
not being able to reference items such as oids, typenames and aliases in
one place is pretty messy.  And like I said earlier, my boss doesn't
want people working on my project to have to search for the scattered
references again.

Maybe I should place that up as a comment/suggestion like you said.
Thanks, again.

Josh

-----Original Message-----
From: John DeSoi [mailto:desoi@pgedit.com]
Sent: Monday, July 10, 2006 6:40 PM
To: Garcia, Joshua
Cc: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] Data Types and Their Aliases


On Jul 10, 2006, at 9:13 PM, Garcia, Joshua wrote:

> Ah...ya I know about pg_type and the manual...those are really the
> best
> references for the aliases huh?

As far as I'm aware. What's wrong with the table? If there is missing
or incomplete information, you can add comments/suggestions to the
documentation page for future improvements.



John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

On 7/12/06, Garcia, Joshua <Joshua.Garcia@xerox.com> wrote:
> I don't mind looking at the source.  Although I don't know what gram.y
> is.  Can someone help me out with what that means?
It's a (b)yacc input file to generate a parser :}

http://en.wikipedia.org/wiki/Yacc



Cheers,
Andrej