Ah!Maybe the reason for such thoughts lies in nature of postgres intervals.SQL:2003 standard paper says:
'There are two classes of intervals. One class, called year-monthintervals, has an express or implied datetimeprecision that includes no fields other than YEAR and MONTH, thoughnot both are req
Sorry meant to add this from the psql command line.
On Saturday 20 May 2006 04:37 pm, Adrian Klaver wrote:
> \z 'table_name'
> Look under access privileges for r and w.
> For further information see-
> http://www.postgresql.org/docs/8.1/interactive/sql-grant.html
>
> On Saturday 20 May 2006 03:11
\z 'table_name'
Look under access privileges for r and w.
For further information see-
http://www.postgresql.org/docs/8.1/interactive/sql-grant.html
On Saturday 20 May 2006 03:11 pm, Bob Pawley wrote:
> How can I determine if my tables are 'read only' or 'read/write'?
>
> Bob
--
Adrian Klaver
On 5/21/06, Nikolay Samokhvalov <[EMAIL PROTECTED]> wrote:
So, in almost all cases everything is OK. But it isn't so
when we should multiply or devide such 'hetorogenious intevals'
("select interval '1 month 1 day';" gives us '15 days 12:00:00')...
You obviously meant "select interval '1 month
On 5/21/06, Brendan Jurd <[EMAIL PROTECTED]> wrote:
Well if you're willing to accept that for the purposes of computing the
aggregates, an interval "month" is equal to 30 days (which is how
avg(interval) already works), then an interval is reducable to a single
quantity -- a number of seconds --
How can I determine if my tables are 'read only' or
'read/write'?
Bob
On 5/20/06, Tom Lane <[EMAIL PROTECTED]> wrote:
If the intervals are all expressed in seconds then sure, the calculation
is straightforward and useful. I'm wondering what happens when nonzero
values of days and months get in there.
Ah!
Maybe the reason for such thoughts lies in nature of post
First of all, stddev doesn't return square of smth - so, why should we
worry about intermediate results? Furthermore, statistics work with
any 'units' and doesn't worry about physical meaning of variance in
any case (for example, what about variance for the set of lifetime
values of people from to
That's because variance of foo is measured in foo^2 units. What isthe square of an interval?
Cheers,DWell if you're willing to accept that for the purposes of computing the aggregates, an interval "month" is equal to 30 days (which is how avg(interval) already works), then an interval is reducable
On Sun, May 21, 2006 at 01:14:15AM +1000, Brendan Jurd wrote:
> Hi all,
>
> I noticed a peculiarity in the default postgres aggregate functions. min(),
> max() and avg() support interval as an input type, but stddev() and
> variance() do not.
>
> Is there a rationale behind this, or is it just s
You can find some helpful grant scripts here:http://pgedit.com/tip/postgresql/access_control_functions
On 5/19/06, Joe Kramer <[EMAIL PROTECTED]> wrote:
Hello,I need to grant all privileges on all objects in database. Withoutusing SUPERUSER.It's strange that GRANT ALL PRIVILEGES ON DATABASE is usel
I am not sure that Postgres needs CPAN. CPAN is particularly useful for
handling dependencies. I doubt that there will be lots of dependencies in
Postgres add ons. So having something like the current system where you
download and build packages from source isn't going to be improved much
with a CP
I think the implementation of postgresql installable packages (and
package-space) should precede this idea. Then, any package management
system can install the packages.
On May 20, 2006, at 2:12 PM, Dawid Kuroczko wrote:
Comrehensive PostgreSQL Archive Network, or CPgAN
¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬
The idea that came up in the -hackers and -advocacy lists, and I think
it should be brought up as a separate thread, in -general.
Backgroud
Once in a while someone comes and suggests adding some package to
postgresql-contrib. Some other person asks for some feature and is directed
at Pgfoundry.
If the intervals are all expressed in seconds then sure, the calculation
is straightforward and useful. I'm wondering what happens when nonzerovalues of days and months get in there.regards, tom laneThe existing logic used in avg(interval) can be seen in backend/utils/adt/t
"Ivan Zolotukhin" <[EMAIL PROTECTED]> writes:
> On 5/20/06, Tom Lane <[EMAIL PROTECTED]> wrote:
>> Is it sensible to calculate standard deviation on intervals? How would
>> you handle the multiple components? I mean, you could certainly define
>> *something*, but how sane/useful would the result
On 5/20/06, Tom Lane <[EMAIL PROTECTED]> wrote:
"Brendan Jurd" <[EMAIL PROTECTED]> writes:
> I noticed a peculiarity in the default postgres aggregate functions. min()=
> ,
> max() and avg() support interval as an input type, but stddev() and
> variance() do not.
> Is there a rationale behind t
"Brendan Jurd" <[EMAIL PROTECTED]> writes:
> I noticed a peculiarity in the default postgres aggregate functions. min()=
> ,
> max() and avg() support interval as an input type, but stddev() and
> variance() do not.
> Is there a rationale behind this, or is it just something that was never
> impl
Hi all,I noticed a peculiarity in the default postgres aggregate functions. min(), max() and avg() support interval as an input type, but stddev() and variance() do not.Is there a rationale behind this, or is it just something that was never implemented?
Regards,BJ
this is a forward of my problem from April.
I have this time gone all the way and re-inited a DB from scratch,
created a new database, documented the import procedure, set the locale
to match but I am still having problems.
For example, look at this match count~
mod=# select count(*) from korean_
On 5/19/06, Tom Lane <[EMAIL PROTECTED]> wrote:
"Ivan Zolotukhin" <[EMAIL PROTECTED]> writes:
> quite ordinary I think. When it hangs I see in `ps auxww` process with
> "VACUUM waiting" in its status.
It's definitely waiting for a lock then.
Yep, I checked that it waits for acquiring AccessExc
On 5/20/06, Martijn van Oosterhout wrote:
Seems you can't use a variable there. Your choices are to build a
string and use EXECUTE, or just do:
SELECT setval('sequence',value);
The EXECUTE string solution did the job. Thank you very much, Martijn.
t.n.a.
---(end of
On Sat, May 20, 2006 at 09:52:29AM +0200, Tomi NA wrote:
> I need to generate a couple of dozen statements reseting my sequences
> so that they're next values are greater than the biggest existing ids.
> The problem is, I can't even form a statement to update one sequence.
> This is what I tried:
I need to generate a couple of dozen statements reseting my sequences
so that they're next values are greater than the biggest existing ids.
The problem is, I can't even form a statement to update one sequence.
This is what I tried:
CREATE OR REPLACE FUNCTION init_sequences() RETURNS void AS
$BOD
24 matches
Mail list logo
