Обсуждение: Data Types and Their Aliases
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.
Thanks,
Josh
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