I would really like postgres to model the alter syntax of mysql, which
is really easy to modify table schema especially to include the AFTER
col_name part.
A) why does the order of the columns in a particular table matter at all?
B) is this any sort of SQL standard?
---(e
Would someone be kind enough to advise this person to update his
antispam software, so that it doesn't include all of australia as
spammers?
Kind Regards,
John Hansen
_
From: System Administrator
Sent: Saturday, May 07, 2
>
> It is really hard to currently alter table schema.
>
> Particularly the order of the table schema.
>
> to move a column position is very hard. worse if your table as
references (and which proper
> tables don't ?)
Doesn't that in itself promote bad progra
Any more information on this?
---
Cade Cairns wrote:
> I will post a patch in a few days. I am extremely busy and don't have
> adequate time. I apologize for not having posted more in the first
> place.
>
> On 27-Mar-05,
Negative, i know what the to_date do.
See the "dt_transacao _/*<=*/_ to_date("
The <= make the first sql equal to second
Second: "dt_transacao _/*<*/_ to_date('0204200500')"
Guilherme Silva
Programador - Planejamento
E-mail: [EMAIL PROTECTED]
Tel/Fax: +55 48 2106-5698
ICQ: #119540871
http://www
I understand you, sorry my english is too bad, ignore the last email.
I will try use to_timestamp.
Thanks.
Guilherme Silva
Programador - Planejamento
E-mail: [EMAIL PROTECTED]
Tel/Fax: +55 48 2106-5698
ICQ: #119540871
http://www.nexxera.com
NEXXERA Tecnologia e Serviços S.A.
"Seu ambiente eletrônic
It is really hard to currently alter
table schema.
Particularly the order of the table
schema.
to move a column position is very
hard. worse if your table as references (and which proper tables don't
?)
I would really like postgres to
model the alter syntax of mysql, which is reall
Guilherme Silva <[EMAIL PROTECTED]> writes:
> Negative, i know what the to_date do.
I don't think you do, because you are feeding it input that it will
ignore --- the hh/mm/ss fields are just being thrown away.
regression=# select to_date('0104200500', 'ddmmHH24MISS');
to_date
-
"Guilherme" <[EMAIL PROTECTED]> writes:
> BILHETAGEM=# select sum(tm_arquivo) from bilhete where
> cd_caixa_postal_principal=1304 AND
> BILHETAGEM-# dt_transacao >= to_date('0104200500', 'ddmmHH24MISS')
> AND
> BILHETAGEM-# dt_transacao <= to_date('01042005235959', 'ddmmHH24MISS');
to_
"Peter van der Meer" <[EMAIL PROTECTED]> writes:
> This query doesn't work:
> INSERT INTO testthis(id, somedate) SELECT 2 as id, '2005-02-02' as
> somedate GROUP BY id, somedate;
> Executing it reports:
> ERROR: column "somedate" is of type date but expression is of type text
The GROUP BY forc
The following bug has been logged online:
Bug reference: 1651
Logged by: Peter van der Meer
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4.7-6
Operating system: Debian Linux (Unstable)
Description:static date field is not recognized automatically when
group
The following bug has been logged online:
Bug reference: 1653
Logged by: Guilherme
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4
Operating system: Linux
Description:Bug in date
Details:
Dear Postgres Support,
I think found a bug in postgres, see the sql:
The following bug has been logged online:
Bug reference: 1652
Logged by: Villiam Manera
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.01
Operating system: linux
Description:pg_restore failed
Details:
from pgAdminIII i've created a backup
and then I've try
I don't see this as half baked error checking, but rather, as error
reporting during a "half baked conversion". I prefer to know when the
converter encounters something it doesn't understand, rather than having
it silently enter nulls into the db.
It was the original error reporting that helped m
On Fri, May 06, 2005 at 02:35:16PM +0200, Dirk Bade wrote:
>
> YES, you were right: the 7.1-binaries were still existent in /usr/bin - I
> wonder how this postmaster could coperate with V8.0.1 !?
If the files (binaries, libraries, headers, etc.) for each version
are installed in different places
15 matches
Mail list logo
