Am not able to understand 2 things about table_privileges and is_grantable.
Can someone please help out with this?
Create a table (acctmast).
Check information_schema.table_privileges - there will not be any records
for this table.
Grant only SELECT permissions to a single user - (dbasr).
A sin
Is there any way to enable statement logging at runtime without a restart?
If not I think that would be a nice feature, as one sometimes need to
debug applications that are already in production..
Thanks!
--
Regards,
Hannes Dorbath
---(end of broadcast)-
am Wed, dem 14.03.2007, um 9:57:41 +0100 mailte Hannes Dorbath folgendes:
> Is there any way to enable statement logging at runtime without a restart?
>
> If not I think that would be a nice feature, as one sometimes need to
> debug applications that are already in production..
set log_stateme
On 3/14/07, Hannes Dorbath <[EMAIL PROTECTED]> wrote:
Is there any way to enable statement logging at runtime without a restart?
If not I think that would be a nice feature, as one sometimes need to
debug applications that are already in production..
change log_min_duration_statement and do pg_
am Wed, dem 14.03.2007, um 10:10:02 +0100 mailte hubert depesz lubaczewski
folgendes:
> On 3/14/07, Hannes Dorbath <[EMAIL PROTECTED]> wrote:
> >Is there any way to enable statement logging at runtime without a restart?
> >If not I think that would be a nice feature, as one sometimes need to
> >d
Hi!
(Consider these UPDATE triggers)
I can't test this for now since I'm not with a test database handy for now,
but I was thinking on what happens to OLD and NEW when running multiple
triggers.
For example, for the first trigger OLD is the equivalent to the data that is
stored at the databas
On 3/14/07, A. Kretschmer <[EMAIL PROTECTED]> wrote:
Not necessary, you can set it via session without reload or restart.
but then it will work only for the connection that did set it. and i
understood that hannes wanted to profile working application - so it's
not really useful.
depesz
--
ht
hubert depesz lubaczewski wrote:
On 3/14/07, A. Kretschmer <[EMAIL PROTECTED]> wrote:
Not necessary, you can set it via session without reload or restart.
but then it will work only for the connection that did set it. and i
understood that hannes wanted to profile working application - so it's
Hello,
Has someone noticed the problem of installation of contribs of
postgreSQL 8.2.3.
I was looking for pgAgent and didn't noticed notting.
Has someone another alternative solution to install it ?
Regards
Ezequias
---(end of broadcast)
Ezequias R. da Rocha wrote:
Hello,
Has someone noticed the problem of installation of contribs of
postgreSQL 8.2.3.
I was looking for pgAgent and didn't noticed notting.
Has someone another alternative solution to install it ?
It's part of pgAdmin, not PostgreSQL
--
Richard Huxton
Richard Huxton escreveu:
Ezequias R. da Rocha wrote:
Hello,
Has someone noticed the problem of installation of contribs of
postgreSQL 8.2.3.
I was looking for pgAgent and didn't noticed notting.
Has someone another alternative solution to install it ?
It's part of pgAdmin, not Postgre
Ezequias R. da Rocha wrote:
Richard Huxton escreveu:
Ezequias R. da Rocha wrote:
Hello,
Has someone noticed the problem of installation of contribs of
postgreSQL 8.2.3.
I was looking for pgAgent and didn't noticed notting.
Has someone another alternative solution to install it ?
It's
Hello,
we are using SCO OpenServer6 and Postgresql 8.1.4.
We increased the parameter max_connections in the postgresql.conf to 300.
In Section 16.4.1 of the dokumentation we try to find out how to adjust
depending parameters. But we can't figure it out.
What would be reasonable values for the
I want to do some debugging on an app, and I'd like to set on a per-
connection basis "set log_min_duration_statement = 10;" Obviously
since I'm not super user I get permission denied.
Is there some GRANT I can grant to the user in question to allow
this? I don't really want to do it globa
I'm running a production database on Linux (select version() =
"PostgreSQL 8.1.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.0.3")
I read that all 8.1.* versions are DST-compliant, and sure enough, my
development server, which runs 8.1.0, switched fine, as did my 8.2.3
database at home.
Th
I'm trying to write a trigger that updates a date_changed field on a
record anytime that record is updated. I have a function written, and
the trigger created, but everytime I update the record, I get a
recursion limit error. It appears that the action performed by my
trigger is causing the trigg
Vivek Khera wrote:
I want to do some debugging on an app, and I'd like to set on a
per-connection basis "set log_min_duration_statement = 10;" Obviously
since I'm not super user I get permission denied.
Is there some GRANT I can grant to the user in question to allow this?
I don't really wa
Jason Lee wrote:
I'm trying to write a trigger that updates a date_changed field on a
record anytime that record is updated. I have a function written, and
the trigger created, but everytime I update the record, I get a
recursion limit error.
[snip]
declare begin
update unit_specification
On 14.03.2007 10:10, hubert depesz lubaczewski wrote:
On 3/14/07, Hannes Dorbath <[EMAIL PROTECTED]> wrote:
Is there any way to enable statement logging at runtime without a
restart?
If not I think that would be a nice feature, as one sometimes need to
debug applications that are already in pro
On Wednesday 14 March 2007 11:15, Jason Lee wrote:
> I'm trying to write a trigger that updates a date_changed field on a
> record anytime that record is updated. I have a function written, and
> the trigger created, but everytime I update the record, I get a
> recursion limit error. It appears t
Jason Lee wrote:
> I'm trying to write a trigger that updates a date_changed field on a
> record anytime that record is updated. I have a function written, and
> the trigger created, but everytime I update the record, I get a
> recursion limit error. It appears that the action performed by my
Yo
Thanks! That did the trick. I had tried that logic in the function,
but I had always used an AFTER trigger, so it didn't work. Thanks,
again. You've saved my sanity. :)
-
Jason Lee, SCJP
Senior Software Engineer
http://www.iec-okc.com
> -Original Message-
> From: Richard Huxton
Jorge Godoy <[EMAIL PROTECTED]> writes:
> If I change some column -- e.g. fill in some automatic calculated column or a
> timestamp column --, when I run the second trigger will OLD be the data stored
> at the database already or will it be affected by the NEW data returned from
> the previous trig
On Wed, 2007-03-14 at 11:16 -0400, Jaime Silvela wrote:
> I'm running a production database on Linux (select version() =
> "PostgreSQL 8.1.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.0.3")
> I read that all 8.1.* versions are DST-compliant, and sure enough, my
> development server, which
Hi,
I'm trying to write a plperl function to copy the new row e.g. NEW in
plpgsql into another table. I was looking for a similar effect to the
INSERT INTO blah VALUES (NEW.*)
Syntax that can be used in plpgsql. So fat the best I have come up with
is:
$collist = "";
$vallist = "";
while (($
Jaime Silvela <[EMAIL PROTECTED]> writes:
> ... before doing that I'd like to find out what's the
> problem with the DST not taking.
> The timezone is 'EST5EDT', and
Is it really 'EST5EDT', or 'est5edt' ? 8.1 is case sensitive about this.
regards, tom lane
On Wed, 2007-03-14 at 12:12 -0400, Tom Lane wrote:
> Jaime Silvela <[EMAIL PROTECTED]> writes:
> > ... before doing that I'd like to find out what's the
> > problem with the DST not taking.
>
> > The timezone is 'EST5EDT', and
>
> Is it really 'EST5EDT', or 'est5edt' ? 8.1 is case sensitive abo
Guy Fraser <[EMAIL PROTECTED]> writes:
> On Wed, 2007-03-14 at 12:12 -0400, Tom Lane wrote:
>> Is it really 'EST5EDT', or 'est5edt' ? 8.1 is case sensitive about this.
> /usr/local/share/postgresql/timezone/EST5EDT
> /usr/local/share/postgresql/timezone/SystemV/EST5EDT
> /usr/share/zoneinfo/EST5E
Are there plans to make Postgresql's behavior SQL compliant with regards
to quoted identifiers? My specific need is to access tables named in
lower case by an uppercase quoted identifier, which is in line with the
SQL standard. So if I created table foo, I should be able to access it
like "FO
A client has PostgreSQL 8.2.1 installed on a Windows 2000 server.
The time on the server is correct but PostgreSQL is returning a time 1 hour in
advance. In other words, it the server time is 1:00 pm, PostgreSQL is
returning 2:00 pm. Both the PostgreSQL server and Windows server have been
reb
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> Are there plans to make Postgresql's behavior SQL compliant with regards
> to quoted identifiers?
No.
> My specific need is to access tables named in lower case by an uppercase
> quoted identifier, which is in line with the SQL standard.
Randall Smith wrote:
> Are there plans to make Postgresql's behavior SQL compliant with
regards
> to quoted identifiers? My specific need is to access tables named in
> lower case by an uppercase quoted identifier, which is in line with
the
> SQL standard. So if I created table foo, I should b
George Weaver wrote:
A client has PostgreSQL 8.2.1 installed on a Windows 2000 server.
W2K has been EOL'ed for quite some time. You might want to stress that to your
client. I don't know what you bill per hour, but their not-upgrading cost
savings should be negative and keep climbing.
Did y
Hi
I'm passing this on second hand so forgive me if I'm a bit vague...
My boss is trying to write a function in PL/pgsql that manipulates a
small, temporary set of data. It fetches about 20 rows from a table
of approx 4 million, then it needs to do further calculations to
narrow them down
Thanks. Yes, I do confirm it was EST5EDT and I ran your regression to
confirm.
I looked for those timezone files, and they're missing on my production
installation. Probably the upgrade from 7.* to 8.1 was a quick&dirty one.
I don't even have a 'timezone' folder in the share directory. Would it
Albe Laurenz wrote:
Randall Smith wrote:
Are there plans to make Postgresql's behavior SQL compliant with
regards
to quoted identifiers? My specific need is to access tables named in
lower case by an uppercase quoted identifier, which is in line with
the
SQL standard. So if I created table
Ashley Moran <[EMAIL PROTECTED]> schrieb:
> The closest I've come from reading the docs is functions that return
> SETOF. However I can't see any way to query the result set like a table.
Right.
> Can anyone offer any hints/links?
select * from .
For instance, if your SRF-function is call
Jaime Silvela <[EMAIL PROTECTED]> writes:
> I looked for those timezone files, and they're missing on my production
> installation. Probably the upgrade from 7.* to 8.1 was a quick&dirty one.
> I don't even have a 'timezone' folder in the share directory.
Oh, that's your problem then --- 'EST5EDT
On Mar 14, 2007, at 6:02 pm, Andreas Kretschmer wrote:
select * from .
For instance, if your SRF-function is called foo(), do:
select * from foo();
Andreas,
It's more complicated than that. What we need to do is something
along the lines of:
results = SELECT * FROM foo();
DELETE FROM
On Mar 14, 2007, at 11:36 AM, Richard Huxton wrote:
Vivek Khera wrote:
I want to do some debugging on an app, and I'd like to set on a
per-connection basis "set log_min_duration_statement = 10;"
Obviously since I'm not super user I get permission denied.
Is there some GRANT I can grant to
Ashley Moran <[EMAIL PROTECTED]> schrieb:
>
> On Mar 14, 2007, at 6:02 pm, Andreas Kretschmer wrote:
> >select * from .
> >For instance, if your SRF-function is called foo(), do:
> >select * from foo();
>
>
> Andreas,
>
> It's more complicated than that. What we need to do is something along
Randall Smith <[EMAIL PROTECTED]> writes:
> I'm an advocate of Postgresql and usually tout SQL compliance as a
> strength, so it bothers me that this is not in line to be corrected.
It's not that it's not on the radar screen, it's just that no one sees
a way to do it that's going to be acceptable
Hi,
I'm attempting to process a query written in the form:
SELECT fields FROM table WHERE conditions FOR UPDATE OF field_name
when Postgresql supports:
SELECT fields FROM table WHERE conditions FOR UPDATE OF table_name
I'd like to remove the OF clause in the case only one table is que
Tom Lane <[EMAIL PROTECTED]> writes:
> Jorge Godoy <[EMAIL PROTECTED]> writes:
>> If I change some column -- e.g. fill in some automatic calculated column or a
>> timestamp column --, when I run the second trigger will OLD be the data
>> stored
>> at the database already or will it be affected by
Ashley Moran <[EMAIL PROTECTED]> writes:
> ... All of which is easy with table variable, but I can't see how to
> translate it to PL/pgsql. Is there any way to manipulate result sets
> in a set-based manner like this?
Sure: use a table. What was the objection to temp tables exactly?
Vivek Khera <[EMAIL PROTECTED]> writes:
> CREATE OR REPLACE FUNCTION setlogtime(integer) RETURNS void AS $$
>SET log_min_duration_statement = $1;
>SHOW log_min_duration_statement;
> $$ LANGUAGE SQL SECURITY DEFINER;
> How can I write this function?
Use a plpgsql EXECUTE command. In gener
George Weaver wrote:
> A client has PostgreSQL 8.2.1 installed on a Windows 2000 server.
>
> The time on the server is correct but PostgreSQL is returning a time 1
> hour in advance. In other words, it the server time is 1:00 pm,
> PostgreSQL is returning 2:00 pm. Both the PostgreSQL server and
I'm guessing that there is no step-wise debugger for pgsql. If there
is, then glory be and call me a dummy for not R'ing TFM.
In fact, I've never heard of a step-wise debugger for any DB server, am
I wrong?
As I grovel through some plPerl code in a statement level trigger that
depends on an
Tom Lane wrote:
Randall Smith <[EMAIL PROTECTED]> writes:
I'm an advocate of Postgresql and usually tout SQL compliance as a
strength, so it bothers me that this is not in line to be corrected.
It's not that it's not on the radar screen, it's just that no one sees
a way to do it that's going t
Kenneth Downs wrote:
> I'm guessing that there is no step-wise debugger for pgsql. If there
> is, then glory be and call me a dummy for not R'ing TFM.
> In fact, I've never heard of a step-wise debugger for any DB server, am
> I wrong?
>
> As I grovel through some plPerl code in a statement level
Kenneth Downs wrote:
> I'm guessing that there is no step-wise debugger for pgsql. If there
> is, then glory be and call me a dummy for not R'ing TFM.
>
> In fact, I've never heard of a step-wise debugger for any DB
> server, am I wrong?
>
Yes. I've done step-wise debugging in Oracle (PL/S
Randall Smith wrote on 14.03.2007 18:59:
I'm trying to get Postgresql to work with software that uses JDBC and
Oracle for a large government project. So I have to report that the
application won't work with Postgresql because it (PG) doesn't adhere to
the standard. That's usually something I
This is the last statement I found on the issue, which is someone hopeful.
http://archives.postgresql.org/pgsql-hackers/2006-11/msg00347.php
Randall
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
On Mar 12, 2007, at 6:08 PM, Martijn van Oosterhout wrote:
On Mon, Mar 12, 2007 at 01:13:42PM -0600, Ed L. wrote:
Would I be correct in understanding that every pre-8.0 cluster
must be restarted in order for the OS changes to take affect?!?
Possibly, I imagine many C libraries would cache th
On Mar 14, 2007, at 2:00 PM, Tom Lane wrote:
Should work to just copy over the timezone directory tree from a
correct
installation on the same machine architecture (I can't recall right
now
if the file format is machine-dependent or not). You might have to
restart the postmaster too, befor
> --- Original Message ---
> From: "Adam Rich" <[EMAIL PROTECTED]>
> To: "'Kenneth Downs'" <[EMAIL PROTECTED]>
> Sent: 14/03/07, 20:06:46
> Subject: Re: [GENERAL] Debugging Server Code
>
> For PostgreSQL, in addition to the pgfoundry solution Joshua mentioned,
> there's also a debugger
Thomas Kellerer wrote:
Randall Smith wrote on 14.03.2007 18:59:
I'm trying to get Postgresql to work with software that uses JDBC and
Oracle for a large government project. So I have to report that the
application won't work with Postgresql because it (PG) doesn't adhere
to the standard. Tha
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 03/14/07 15:23, Vivek Khera wrote:
>
> On Mar 12, 2007, at 6:08 PM, Martijn van Oosterhout wrote:
>
>> On Mon, Mar 12, 2007 at 01:13:42PM -0600, Ed L. wrote:
>>> Would I be correct in understanding that every pre-8.0 cluster
>>> must be restarted
On 14/03/2007 20:26, Dave Page wrote:
The next major version of pgAdmin will also include the native (ie.
non-java) version of the debugger client.
Fantastic! When d'you think it might be out? Is it available in a
development version to play with yet?
Ray.
-
- Original Message -
From: "Randall Smith" <[EMAIL PROTECTED]>
I'll give the pghackers forum a visit and since I'm already on the subject
here, I'll make a direct comparison of the situation. Microsoft's Internet
Explorer web browser is known to have poor support for the CSS standard
Ashley Moran wrote:
It fetches about 20 rows from a table of approx 4 million, then it
needs to do further calculations to narrow them down further.
Previously we have only written database code for SQL Server, and
there we would use a table variable. Apparently temporary tables are
not equi
I am writing scripts to create a database that I want to run in my
development, testing, and production environments. That means I need to
be able to do something like
IF
CREATE TABLESPACE foo LOCATION E'C:\database';
ELSE
CREATE TABLESPACE foo LOCATION E'Z:\database';
I can't seem to fi
> --- Original Message ---
> From: "Raymond O'Donnell" <[EMAIL PROTECTED]>
> To: "'pgsql general'"
> Sent: 14/03/07, 20:51:33
> Subject: Re: [GENERAL] Debugging Server Code
>
> On 14/03/2007 20:26, Dave Page wrote:
>
> > The next major version of pgAdmin will also include the native (i
William Garrison wrote:
I am writing scripts to create a database that I want to run in my
development, testing, and production environments. That means I need to
be able to do something like
IF
CREATE TABLESPACE foo LOCATION E'C:\database';
ELSE
CREATE TABLESPACE foo LOCATION E'Z:\datab
Ted Byers wrote:
- Original Message - From: "Randall Smith" <[EMAIL PROTECTED]>
I'll give the pghackers forum a visit and since I'm already on the
subject here, I'll make a direct comparison of the situation.
Microsoft's Internet Explorer web browser is known to have poor
support fo
This whole discussion is reminding me of one of my personal mantras, and
that is that relying on "artifacts" of behaviour is generally a bad
idea.
For instance, many databases accept != for not equal, but the sql
standard quite clearly says it's <>.
If you're relying on case folding meaning that
Answers in place:
I'm trying to write a plperl function to copy the new row e.g. NEW in
plpgsql into another table. I was looking for a similar effect to the
INSERT INTO blah VALUES (NEW.*)
Syntax that can be used in plpgsql. So fat the best I have come up with
is:
$collist = "";
$val
I copied the files over, restarted, and everything's fine.
Tom Lane wrote:
Jaime Silvela <[EMAIL PROTECTED]> writes:
I looked for those timezone files, and they're missing on my production
installation. Probably the upgrade from 7.* to 8.1 was a quick&dirty one.
I don't even have a 'timezon
Scott Marlowe wrote:
This whole discussion is reminding me of one of my personal mantras, and
that is that relying on "artifacts" of behaviour is generally a bad
idea.
For instance, many databases accept != for not equal, but the sql
standard quite clearly says it's <>.
If you're relying on cas
Randall Smith wrote:
> Scott Marlowe wrote:
> >This whole discussion is reminding me of one of my personal mantras, and
> >that is that relying on "artifacts" of behaviour is generally a bad
> >idea.
> >
> >For instance, many databases accept != for not equal, but the sql
> >standard quite clearly
On Wed, 14 Mar 2007 12:56:25 -0700, "Joshua D. Drake" <[EMAIL PROTECTED]> wrote:
> It certainly would be great. IIRC there is actually one for plpgsql over
> at pgfoundry.
Do you remember what it's called? In the search for plpgsql I get
pgflows, plpsm, and enterprise db's debugger (which the sum
On Mar 14, 2007, at 7:25 pm, Tom Lane wrote:
Sure: use a table. What was the objection to temp tables exactly?
My boss is under the impression that calling the procedure twice on
the same connection creates a name conflict for the temporary table.
Also I'm unsure how the use of temporary
> Sorry my sheer ignorance here. I have already written a working, fully
> tested - albeit unoptimised - implementation of this algorithm in Ruby,
> accessible as a basic (HTTP GET) web service. However, a developer here
> believes that the overhead of an HTTP connection over our gigabit LAN
> w
Ashley Moran wrote:
>
> On Mar 14, 2007, at 7:25 pm, Tom Lane wrote:
> >Sure: use a table. What was the objection to temp tables exactly?
>
> My boss is under the impression that calling the procedure twice on
> the same connection creates a name conflict for the temporary table.
>
> Also I'm
Hi ,
I'm facing frustrating problem with locking in
postgres server. I have application which do update
one table few thousands time each minute. From time to
time call to database is locked and is waiting for
something
(In pgAdmin3 in 'Server Status' window in 'Lock' tab I
can see UPDATE stateme
Hello,
What is the lifecycle of a 8.0/8.1/8.2 releases? With 8.3 scheduled to be
released in July, what will be the status of the 7.4.x branch?
We are planning pg upgrades from 8.0.x/7.4.x to 6.2.x and were wondering if
it's worth waiting for the 8.3 release.
Thanks in advance!
This may be a dupe. I sent and had some issues with my mail client
and afterwards it was sitting all alone in my outbox, if you've
already seen this, sorry for the resend...
On Mar 14, 2007, at 2:08 PM, Randall Smith wrote:
Hi,
I'm attempting to process a query written in the form:
S
On Mar 14, 2007, at 6:17 PM, CAJ CAJ wrote:
Hello,
What is the lifecycle of a 8.0/8.1/8.2 releases? With 8.3 scheduled
to be released in July, what will be the status of the 7.4.x branch?
We are planning pg upgrades from 8.0.x/7.4.x to 6.2.x and were
wondering if it's worth waiting for th
On Wed, 14 Mar 2007, Randall Smith wrote:
> Scott Marlowe wrote:
> > This whole discussion is reminding me of one of my personal mantras, and
> > that is that relying on "artifacts" of behaviour is generally a bad
> > idea.
> >
> > For instance, many databases accept != for not equal, but the sql
I have a problem with query optimization. Since it's a bit hard to
explain, I'll describe the database structure and list the queries
first. The database holds contacts information for a call center. The
general idea is to have operators call a random contact and record
the results. Rules for pick
Erik Jones wrote:
> On Mar 14, 2007, at 6:17 PM, CAJ CAJ wrote:
>
>> Hello,
>>
>> What is the lifecycle of a 8.0/8.1/8.2 releases? With 8.3 scheduled to
>> be released in July, what will be the status of the 7.4.x branch?
>>
>> We are planning pg upgrades from 8.0.x/7.4.x to 6.2.x and were
>> wond
In SQL servers in general, or in PG, is there a native field type to
store fractions? Or must one resort to char or separate
numerator/denominator columns?
Thanks,
Ken
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
Consider the case where an AFTER STATEMENT trigger calls a plperl
function which performs a loop. Inside of the loop it updates at least
one other table.
The table being updated has an AFTER STATEMENT trigger that calls the
same plperl function (w/different parms of course), which goes into
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Ashley Moran wrote:
>> Also I'm unsure how the use of temporary tables will affect the
>> running of the query. This function will be called up to 400 times
>> by a wrapping function that needs to complete quickly (relatively -
>> the calculations
Alvaro Herrera wrote:
Randall Smith wrote:
Scott Marlowe wrote:
This whole discussion is reminding me of one of my personal mantras, and
that is that relying on "artifacts" of behaviour is generally a bad
idea.
For instance, many databases accept != for not equal, but the sql
standard quite cl
Stephan Szabo wrote:
On Wed, 14 Mar 2007, Randall Smith wrote:
Scott Marlowe wrote:
This whole discussion is reminding me of one of my personal mantras, and
that is that relying on "artifacts" of behaviour is generally a bad
idea.
For instance, many databases accept != for not equal, but the
Erik Jones wrote:
This may be a dupe. I sent and had some issues with my mail client and
afterwards it was sitting all alone in my outbox, if you've already seen
this, sorry for the resend...
On Mar 14, 2007, at 2:08 PM, Randall Smith wrote:
Hi,
I'm attempting to process a query written in
I need advice, and a lot of it, from those with more experience, since
I have practically none. Please, let me know your opinion on the
following.
We have an in-house Postgres database that we would like to make
publicly accessible via a password-less login (user: anonymous). (We
already have a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 03/14/07 18:55, Ken Johanson wrote:
> In SQL servers in general, or in PG, is there a native field type to
> store fractions? Or must one resort to char or separate
> numerator/denominator columns?
1/3 repeats ad infinitum, and '1/3' would have to
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> Erik Jones wrote:
>> I really hope you meant upgrades to 8.2.x. And, no, it's not worth
>> waiting. Upgrade at the soonest available opportunity, expecially the
>> 7.4.x servers.
> I don't really agree with this. If he is running 7.4.16 there very
Tom Lane wrote:
> "Joshua D. Drake" <[EMAIL PROTECTED]> writes:
>> Erik Jones wrote:
>>> I really hope you meant upgrades to 8.2.x. And, no, it's not worth
>>> waiting. Upgrade at the soonest available opportunity, expecially the
>>> 7.4.x servers.
>
>> I don't really agree with this. If he is r
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> I can't really argue for 8.2 versus 8.3, but I can argue that as 8.3 is
> literally around the corner, it may make sense to wait.
Today is the ides of March ... while the most optimistic estimate I've
heard for 8.3 release is high summer. Maybe that
Ron Johnson wrote:
> On 03/14/07 18:55, Ken Johanson wrote:
> > In SQL servers in general, or in PG, is there a native field type
> > to store fractions? Or must one resort to char or separate
> > numerator/denominator columns?
>
> 1/3 repeats ad infinitum, and '1/3' would have to be converted to
>
93 matches
Mail list logo
