pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Thomas G. Lockhart <lockhart@alumni.caltech.edu>
To: Matthew Hagerty <matthew@wolfepub.com>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Data types and binary data
Date: Thu, 20 Aug 1998 05:12:51 +0000
Message-ID: <35DBB053.B379F9F2@alumni.caltech.edu> (raw)
References: <3.0.1.32.19980819223717.006a8d04@wolfepub.com>

> Where can I find a *complete* list of postgresql data types?  I have 
> looked all over the web site and found what seems to be a partial 
> list.  I assume it to be partial because I see no reference to the 
> text, name, filename, etc. types.

Hmm. I updated the User's Guide html document on the web site the other
day, and put tar files of the html in /pub/patches/*.tar.gz

Pretty sure I don't mention "filename" in the docs, but am certain I
talk about "text" and mention "name" in passing. Look inside the chapter
on Data Types, in the section on Character Types.

I also forgot to discuss the "oid" type; if there are any others missing
from the docs let me know. Others should speak up too if they see
omissions; that's "my" chapter :)

> Also, is there an equivilant of the CAE specification (1992) 
> Extended-SQL data type binary(n)?

Don't know. What does it do? Is the same as a blob? If so, then you need
to use the large object interface.

                      - Tom



view thread (4+ messages)  latest in thread

Message-ID: <35DBB053.B379F9F2@alumni.caltech.edu>
Permalink:  ../35DBB053.B379F9F2@alumni.caltech.edu/
Also on:    postgresql.org/message-id/35DBB053.B379F9F2@alumni.caltech.edu

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: lockhart@alumni.caltech.edu, matthew@wolfepub.com
  Subject: Re: [INTERFACES] Data types and binary data
  In-Reply-To: <35DBB053.B379F9F2@alumni.caltech.edu>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox