Enumerated (enum) types are data types that are comprised of a static,
predefined set of values with a specific order. They are equivalent to the
enum types in a number of programming languages. An example of an enum type
might be the days of the week, or a set of status values for a piece of
data.
In article <[EMAIL PROTECTED]>,
"Michael Lourant" <[EMAIL PROTECTED]> writes:
> Type Safety
> Enumerated types are completely separate data types and may not be compared
> with each other.
...
> An Alternative Way To Do The Same
> Instead of using an enum type we can set up a CHECK CONSTRAINT
On Mon, May 26, 2008 at 9:34 PM, Sebastian Rychter
<[EMAIL PROTECTED]> wrote:
> I'll keep on looking for any other differences on different logs.. I think I
> already searched all the Postgresql forums I know and no one ever reported
> something like that before.
There is one other thing that you
I need to update some records in a table depending on values in another
table:
UPDATE
item SET export_time = now()
WHERE item_pk IN
(
SELECT
item.item_pk AS pk
FROM ITEM
LEFT JOIN product product ON Item.product_fk = product.product_pk
WHERE product.xyz = 't' AND ...
)
Is this the most
Thank you!
Very educational and started a few wheels turning for
an application.
Would you please comment on enum's sql compatibility
and portability?
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] on behalf of Michael Lourant
Sent: Tue 5/27/2008 7:29
At 09:20 PM 5/27/2008, [EMAIL PROTECTED] wrote:
Date: Tue, 27 May 2008 09:29:56 -0700
From: "Richard Broersma" <[EMAIL PROTECTED]>
To: "Sebastian Rychter" <[EMAIL PROTECTED]>
Cc: pgsql-sql@postgresql.org
Subject: Re: Extremely Low performance with ODBC
Message-ID:
<[EMAIL PROTECTED]>
On Mon, M
At 09:20 PM 5/27/2008, [EMAIL PROTECTED] wrote:
Date: Tue, 27 May 2008 09:29:56 -0700
From: "Richard Broersma" <[EMAIL PROTECTED]>
To: "Sebastian Rychter" <[EMAIL PROTECTED]>
Cc: pgsql-sql@postgresql.org
Subject: Re: Extremely Low performance with ODBC
Message-ID:
<[EMAIL PROTECTED]>
On Mon, M
