pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Harald Fuchs <use_reply_to@protecting.net>
To: pgsql-performance@postgresql.org
Subject: Re: How to read query plan
Date: 14 Mar 2005 15:05:52 +0100
Message-ID: <puekei9vb3.fsf@srv.protecting.net> (raw)
References: <42345D24.8070104@startnet.cz>
	<4234692E.3050802@arbash-meinel.com>
	<42347407.2000202@startnet.cz>
	<42347D5E.9000900@arbash-meinel.com>
	<42348F54.1000408@startnet.cz>
	<423493E5.6040203@arbash-meinel.com>
	<42355249.8090101@startnet.cz>
	<opsnmecyijth1vuj@localhost>
	<423556B8.4020500@startnet.cz>

In article <423556B8.4020500@startnet.cz>,
=?ISO-8859-15?Q?Miroslav_=A6ulc?= <miroslav.sulc@startnet.cz> writes:

>> Instead of a varchar(1) containing 'y' or 'n' you could use a
>> BOOL or an  integer.

> Sure I could. The problem is our project still supports both MySQL and
> PostgreSQL. We used enum('Y','N') in MySQL so there would be a lot of
> changes in the code if we would change to the BOOL data type.

Since BOOL is exactly what you want to express and since MySQL also
supports BOOL (*), you should make that change anyway.

(*) MySQL recognizes BOOL as a column type and silently uses
TINYINT(1) instead.




view thread (37+ messages)  latest in thread

Message-ID: <puekei9vb3.fsf@srv.protecting.net>
Permalink:  ../puekei9vb3.fsf@srv.protecting.net/
Also on:    postgresql.org/message-id/puekei9vb3.fsf@srv.protecting.net

 · 

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-performance@postgresql.org
  Cc: use_reply_to@protecting.net
  Subject: Re: How to read query plan
  In-Reply-To: <puekei9vb3.fsf@srv.protecting.net>

* 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