pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Grzegorz Szpetkowski <gszpetkowski@gmail.com>
To: pgsql-sql@postgresql.org
Subject: BINARY and BINARY VARYING datatypes in PostgreSQL
Date: Mon, 2 May 2011 12:46:40 +0200
Message-ID: <BANLkTi=8Ws27gAVkQY44gf9OH2j_+kME2w@mail.gmail.com> (raw)

I know that BIT and BIT VARYING types were deleted from SQL:2003 and
there are "old new" BINARY, BINARY VARYING in SQL:2008. I have two
question:

1) Are these types technically the same (I mean implementation things) ?
2) Is PostgreSQL aim to support BINARY, BINARY VARYING in 9.1 and
leave BIT and BIT VARYING for backward compability (for example as
aliases) ?

"PostgreSQL supports most of the major features of SQL:2008. Out of
179 mandatory features required for full Core conformance, PostgreSQL
conforms to at least 160. In addition, there is a long list of
supported optional features. It might be worth noting that at the time
of writing, no current version of any database management system
claims full conformance to Core SQL:2008."

from: http://developer.postgresql.org/pgdocs/postgres/features.html

Regards,
Grzegorz Szpetkowski



view thread (3+ messages)  latest in thread

Message-ID: <BANLkTi=8Ws27gAVkQY44gf9OH2j_+kME2w@mail.gmail.com>
Permalink:  ../BANLkTi=8Ws27gAVkQY44gf9OH2j_+kME2w@mail.gmail.com/
Also on:    postgresql.org/message-id/BANLkTi=8Ws27gAVkQY44gf9OH2j_+kME2w@mail.gmail.com

 · 

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-sql@postgresql.org
  Cc: gszpetkowski@gmail.com
  Subject: Re: BINARY and BINARY VARYING datatypes in PostgreSQL
  In-Reply-To: <BANLkTi=8Ws27gAVkQY44gf9OH2j_+kME2w@mail.gmail.com>

* 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