Re: [HACKERS] Problems with CREATE AGGREGATE and user defined state type.
delete my email from the list Regards, -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Magnus Jonsson Sent: Tuesday, March 21, 2006 8:39 PM To: pgsql-hackers@postgresql.org Subject: [HACKERS] Problems with CREATE AGGREGATE and user defined state type. Hello, I discoverd what seems to be a bug in postgresql 7.4.12 (also on 7.4.7). I have an example located at http://foo.fot.nu/psql/ with a simple example that delevers the correct result on 8.1 (tested by some nice person at #postgresql). It seems like the state variable is reseted every time a new grouped value pops up. /M -- Magnus Jonsson [EMAIL PROTECTED] I'm here looking for an answer, but I'm not sure about the question... ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] Modular Type Libraries: was A real currency type
remove my email from the list Regards, -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Andrew Dunstan Sent: Wednesday, March 22, 2006 9:05 AM To: [EMAIL PROTECTED] Cc: pgsql-hackers@postgresql.org Subject: Re: [HACKERS] Modular Type Libraries: was A real currency type Trent Shipley said: Without directly addressing the merits of enumerations, enumeration interfaces, real currency and time zone types, or whether currency and time zone types should be built using enumerations, I would like to ask the powers-that-be to seriously consider radically modularizing Postgresql's type system. The core Postgresql installation would come with just those built-in types needed to bootstrap itself, perhaps just varchar and an integer type. Everything else would be a contributed module. An interface or contract would be described for creating additional types. It would include things like parameter handlers, how to dump the type, and how to load the type. (That is, standard housekeeping functions needed by the Postgresql engine.) Other that the tiny number of bootstrap types, Postgresql types would basically all be contrib modules. Types could be bundled into groups such as binary, character, numerical, 2d-spatial, networking, and so on. Then one would not debate whether a type (or meta-type, like an enumeration) should be put into the core product. Instead, the debate would be whether or not to grade the type as mature and whether or not to put a given type into pre-packaged type libraries with names like legacy, sql-2003-standard, or recommended-default. Power user DBA's could customize the types offered on their systems. In short: 1) Types would be modular. This would be elegant, but have no practical effect on database performance. 2) The framework needed to support modular types would encourage type development. This would enhance Postgresql's adaptability which would be A Very Good Thing. We already have good support of type development. It's not clear to me that this would buy us anything at all. It seems like modularisation for the sake of it. The real issue is what types and type mechanisms should be in the postgresql core distribution. We won't win any thanks from anyone if we reduce them. Getting some types right is hard. There is no case that I can see for pushing timestamps, numerics, bitstrings or geometric or network types out of the core - they need all the support they can get. I'm also not sure which of these are required by the SQL spec. cheers andrew ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[HACKERS] unsubscribe
unsubscribe ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [HACKERS] Offer for PG Developers/Hackers
Hi Tony, I am using PD Admin as a client, to connect PostgresSQL in windows environment, It is not much flexibale. I am highly obliged if i can get free copy of PG Lightning Admin. Regards, AFTAB ALAM -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Tony Caduto Sent: Tuesday, January 24, 2006 1:29 PM To: pgsql-hackers Subject: [HACKERS] Offer for PG Developers/Hackers Hi, I want to give something back(I would give a donation but sales are poor :-( ,so I am offering to any verified Postgresql developer(by verified I mean your name shows up on this list a LOT ) a free copy of PG Lightning Admin. I know most of you guys don't use windows, but if you do your welcome to a copy. There are no strings attached and you don't have to do anything other than keeping the setup password to yourself. Just let me know via email. Thanks, -- Tony Caduto AM Software Design Home of PG Lightning Admin for Postgresql http://www.amsoftwaredesign.com ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[HACKERS] sending mail from Postgres
Hi there, How can i send mail form postgresql. any suggestion. thanx regards aftab ---(end of broadcast)--- TIP 6: explain analyze is your friend
[HACKERS] delete trigger
Hello, I want to create a trigger in PostgresSQL In trigger, Before inserting the record, if data is already in the table, the trigger fire the mesaage that data is already there, and after that trigger ckeck for next insert statement. Pleae help me in this regard,kindly reply. Regards, _ Aftab Alam