On Tue, 19 Sep 2006, Alvaro Herrera wrote:
Jeremy Drake wrote:
I have found the same thing with the type timestamp without time zone.
The verbosity of type names seems rather extreme.
Then use simply timestamptz (with TZ) or timestamp (without).
Didn't know about these, learn something
Jeremy Drake wrote:
On Tue, 19 Sep 2006, Alvaro Herrera wrote:
Jeremy Drake wrote:
I have found the same thing with the type timestamp without time
zone.
The verbosity of type names seems rather extreme.
Then use simply timestamptz (with TZ) or timestamp (without).
Didn't know about
Jeremy Drake wrote:
I have found the same thing with the type timestamp without time zone.
The verbosity of type names seems rather extreme.
Then use simply timestamptz (with TZ) or timestamp (without).
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL
On Sep 15, 2006, at 11:32 PM, Jeremy Drake wrote:
When I was first dealing with postgres, I found it extremely
annoying that
I had to type out double precision rather than just double
since every
sane programming language (as well as Java) uses double. I eventually
figured out that it was
I've send the comment below to the documentation page about CREATE
FUNCTION, but it got (rightfully) rejected, since it doesn't really
add up to the discussion and is more of a request about syntax. So,
here it goes:
Sorry, but datetime vs timestamp with time zone?! And what about
the whole
Please, take this as constructive criticism, since i'm a proud
open-source supporter... i would gladly use PostgreSQL at work,
clunkier syntax or not, but it's otherwise difficult to sell it to my
Windows-minded coworkers...
I would love to take this as constructive criticism, but you haven't
Ricardo Malafaia [EMAIL PROTECTED] writes:
Sorry, but datetime vs timestamp with time zone?! And what about
the whole function text between $$'s? Yes, better than the '' of some
time ago, since we don't have to put string literals in the function
text between 's! still...
timestamp with
Ricardo Malafaia wrote:
I've send the comment below to the documentation page about CREATE
FUNCTION, but it got (rightfully) rejected, since it doesn't really
add up to the discussion and is more of a request about syntax. So,
here it goes:
Sorry, but datetime vs timestamp with time zone?!
well, ain't that surprising to see so many open-source developers
living in denial and sugestions to RTFM rather than actually coping
wth the problem? are you to be taken seriously?
As a C programmer, I'm in the same league as most of you guys, so
while i can really contribute code and my talk
On Fri, Sep 15, 2006 at 12:35:03PM -0300, Ricardo Malafaia wrote:
On 9/15/06, Andrew Dunstan [EMAIL PROTECTED] wrote:
Where is the mention of either of these on the CREATE FUNCTION page?
http://www.postgresql.org/docs/8.1/interactive/sql-createfunction.html
Err, in the example? So you're not
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Ricardo Malafaia
Sent: 15 September 2006 16:35
To: Andrew Dunstan
Cc: pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] polite request about syntax
my complaint is that, like i said
The only person in denial is you. Here's a hard lesson about open
source: bitching gets you nothing.
YOU are not going to be taken seriously while all you do is complain.
And if you must complain, make sure the politeness is in the words, not
just the subject.
The only place timestamp is
Ricardo Malafaia [EMAIL PROTECTED] writes:
my complaint is that, like i said, timestamp with time zone is no
good substitute for a simple datetime. Here, someone suggested a
CREATE DOMAIN to create an alias for it. Why isn't it provided there
out-of-the-box by default? So you have the SQL
-- Forwarded message --
From: Ricardo Malafaia [EMAIL PROTECTED]
Date: Sep 15, 2006 1:28 PM
Subject: Re: [HACKERS] polite request about syntax
To: Tom Lane [EMAIL PROTECTED]
ok, guys. i guess i was a bit unfair. Timestamp is used everywhere
indeed, Oracle, Firebird you name
Ricardo Malafaia [EMAIL PROTECTED] writes:
What happens then when it sees something like a double variable
interpolation as in $$foobar? ;)
Then you use $FOO$ (or something else that doesn't appear in your
code) as the delimiter--you're not limited to just $$.
-Doug
On 9/15/06, Douglas McNaught [EMAIL PROTECTED] wrote:
What happens then when it sees something like a double variable
interpolation as in $$foobar? ;)
Then you use $FOO$ (or something else that doesn't appear in your
code) as the delimiter--you're not limited to just $$.
clever. still, i
Ricardo Malafaia wrote:
And the $$ is indeed needed for allowing languages with different
syntaxes. agreed. However, Tom, i could counter example your plperl
example:
realize that qq/end/ does not represent a matching end?
What happens then when it sees something like a double variable
Ricardo Malafaia wrote:
On 9/15/06, Douglas McNaught [EMAIL PROTECTED] wrote:
What happens then when it sees something like a double variable
interpolation as in $$foobar? ;)
Then you use $FOO$ (or something else that doesn't appear in your
code) as the delimiter--you're not limited to
On Fri, 15 Sep 2006, Dave Page wrote:
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Ricardo Malafaia
Sent: 15 September 2006 16:35
To: Andrew Dunstan
Cc: pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] polite request about syntax
19 matches
Mail list logo