Re: [GENERAL] question about hstore and indexes

-- Matteo Beccati Development Consulting - http://www.beccati.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Immutable function with bind value

here https://gist.github.com/e93792540cb3a68054c9 (it happens at least in pg 8.4 and 9.1.2) What do you think about it... bug? feature? how can i avoid it? How about: PREPARE test (varchar) as select * from test where a = $1; EXECUTE test(test_immutable(1)); Cheers -- Matteo

Re: [GENERAL] Odd behaviour of timestamptz

the issue. Thanks everyone for the help and explanations! Best regards -- Matteo Beccati http://phpadsnew.com http://phppgads.com ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[GENERAL] Odd behaviour of timestamptz

) Best regards -- Matteo Beccati http://phpadsnew.com http://phppgads.com ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Odd behaviour of timestamptz

Matteo Beccati ha scritto: Hi, I've been recently pointed out an issue with timestamptz on a fedora box and no one was able to replicate it on other machines. After a quick chat on the IRC at least another two people could replicate the issue and all of them were using an RPM package

Re: [GENERAL] Odd behaviour of timestamptz

-integer-datetimes. I could understand problems representing microseconds, but not the time zone... Best regards -- Matteo Beccati http://phpadsnew.com http://phppgads.com ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ

Re: [GENERAL] Announce: GPL Framework centered on Postgres

. Best regards -- Matteo Beccati http://phpadsnew.com http://phppgads.com ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get

Re: [GENERAL] pl/pgsql oddity

Hi, l = 38; This should be: l := 38; otherwise l would remain uninitialized (NULL). Ciao ciao -- Matteo Beccati http://phpadsnew.com http://phppgads.com ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http

Re: [GENERAL] Can COPY skip a header line?

Hi, Can I get PHP to remove the first row without reading the whole file in? If there was a way where PHP would just chop the first row off that would be ideal... If you are using COPY table FROM stdin and pg_put_line() it's not much difficult to skip the first line ;) Best regards -- Matteo

Re: [GENERAL] query with table alias

your query get rewritten as: select foo.c1, f.c2 from foo f, foo; You should also receive a: NOTICE: adding missing FROM-clause entry for table foo Best regards -- Matteo Beccati http://phpadsnew.com http://phppgads.com ---(end of broadcast)--- TIP

Re: [GENERAL] Strange UTF-8 behaviour

Hi, (UTF-8 encoded) Sorry, I actually forgot to switch encoding :) I just hope the last part of the email was readable. Ciao ciao -- Matteo Beccati http://phpadsnew.com/ http://phppgads.com/ ---(end of broadcast)--- TIP 3: if posting/reading through

Re: [GENERAL] most idiomatic way to update or insert?

. In fact, INSERTs were sometimes failing because of concurrency, and this was the only viable solution I found to avoid losing data. Best regards -- Matteo Beccati http://phpadsnew.com/ http://phppgads.com/ ---(end of broadcast)--- TIP 3: if posting