Carlos Mennens writes:
> Does it matter when writing SQL code in PostgreSQL if I use DECIMAL or
> NUMERIC date types for a column named 'price' assuming it's to store
> the associated items actual dollar amount?
No, because they're the same type in Postgres, as you were already told
last week:
ht
Does it matter when writing SQL code in PostgreSQL if I use DECIMAL or
NUMERIC date types for a column named 'price' assuming it's to store
the associated items actual dollar amount?
Reading the fine manual*, I can't find a single difference between
either and they both are supported / recognized
Should match to the data type of the filtered value, so CHAR,VARCHAR,All DATE
TYPES should be quoted. INTEGER, BIGINT, SMALLINT should not
-Original Message-
From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-ow...@postgresql.org] On
Behalf Of Carlos Mennens
Sent: Thursday, Jan
I'm trying to understand when in SELECT statements should and should I
not use single quotes to filter my results. For example:
SELECT * FROM people
WHERE fname = 'James';
or
SELECT * FROM price
WHERE msrb
BETWEEN 50 AND 100;
Now is it correct to say that in PostgreSQL or ANSI SQL in general I
would someone with the appropriate authority please unsubscribe this
person's email address from this list so we don't all get a bounce message
after every email we send to the list? Thanks.
--sam
-- Forwarded message --
From: Jan Verheyden
Date: 2012/1/2
Subject: Re: [SQL] i w