am Sun, dem 03.09.2006, um 14:24:41 -0700 mailte Bob Pawley folgendes:
> I have a column that I wish to use to designate loop numbers.
>
> A loop number is composed of a letter (F for flow, T for temperatures etc.)
> followed by a sequence number starting at one and ending with the last loop.
>
"Sean O'Loughlin" <[EMAIL PROTECTED]> writes:
> Hi all,
> I have a question about how a certain function would look. Basically, what I
> want to do is
> having something that would take in a 'from' date (day, month, year) and a
> 'to' date (also day,
> month and year) and then spit back a series
[EMAIL PROTECTED] wrote:
Hi,
I have a program which uses Postgresql as a database for persistence.
The application uses IzPack to install.
Ideally I would like to also install Postgresql in the same wizard
conversation, plus get it up and running as a windows service (or
daemon on 'nix).
Is al
"Frank Church" <[EMAIL PROTECTED]> writes:
> I tried the query in this form:
> select *, "timestamp" * interval '1 second' + timestamp '1900-01-01
> 00:00:00' from ccmanager_log
Try timestamp plus interval, instead of the other way. (We did add the
operator in this direction in 8.0 though ... pe
Ron Johnson <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> zeljko <[EMAIL PROTECTED]> writes:
>>> Is there any plans (or somebody already working on) to see compressed
>>> protocol in 8.2 ?
>>
>> Why bother? Run your session through an ssh tunnel and ask it to
>> compress.
> Wouldn't that add
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tom Lane wrote:
> zeljko <[EMAIL PROTECTED]> writes:
>> Is there any plans (or somebody already working on) to see compressed
>> protocol in 8.2 ?
>
> Why bother? Run your session through an ssh tunnel and ask it to
> compress.
Wouldn't that add ext
Peter's suggestion did not work.
On 9/4/06, Michael Glaesemann <[EMAIL PROTECTED]> wrote:
Please reply to the list so that others may contribute to and learn
from the discussion.
I am now getting familiar with google mail
On Sep 4, 2006, at 8:34 , Frank Church wrote:
> ERROR: function to
On 9/4/06, Peter Eisentraut <[EMAIL PROTECTED]> wrote:
Frank Church wrote:
> error: cannot cast tupe double precision to timestamp without time
> zone
>
> What is the right syntax?
It's not clear what the meaning of a double precision as a timestamp
would be. How about you make that explicit:
Please reply to the list so that others may contribute to and learn
from the discussion.
On Sep 4, 2006, at 8:34 , Frank Church wrote:
ERROR: function to_timestamp(double precision) does not exist
HINT: No function matches the given name and argument types. You may
need to add explicit ty
zeljko <[EMAIL PROTECTED]> writes:
> Is there any plans (or somebody already working on) to see compressed
> protocol in 8.2 ?
Why bother? Run your session through an ssh tunnel and ask it to
compress.
regards, tom lane
---(end of broadcast)--
Frank Church wrote:
> error: cannot cast tupe double precision to timestamp without time
> zone
>
> What is the right syntax?
It's not clear what the meaning of a double precision as a timestamp
would be. How about you make that explicit:
"timestamp" * interval '1 second' + timestamp '1900-01-0
On Sep 4, 2006, at 7:57 , Frank Church wrote:
I am trying to create a view based on this query
'select *, "timestamp"::timestamp from ccmanager_log'
What is the right syntax?
Try this:
select *, to_timestamp("timestamp") from ccmanager_log
http://www.postgresql.org/docs/current/intera
I am trying to create a view based on this query
'select *, "timestamp"::timestamp from ccmanager_log'
This is the error I get to below, how do I use the time zone syntax
error: cannot cast tupe double precision to timestamp without time zone
What is the right syntax?
The column to be conve
On Sunday 03 September 2006 02:24 pm, Bob Pawley wrote:
> I have a column that I wish to use to designate loop numbers.
>
> A loop number is composed of a letter (F for flow, T for temperatures etc.)
> followed by a sequence number starting at one and ending with the last
> loop.
>
> The loop numbe
In article <[EMAIL PROTECTED]>, Florian G. Pflug <[EMAIL PROTECTED]> wrote:
% You could try doing:
%
% begin;
% select 1;
% select 1;
% ...
% rollback;
Yes, I tried that, but each select is on the order of 100ms.
% off. If that doesn't reveal a possible cause, then I'd suggest that
% you strace
Is there any plans (or somebody already working on) to see compressed
protocol in 8.2 ?
zac
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
In article <[EMAIL PROTECTED]>,
Rafael Barrera Oro <[EMAIL PROTECTED]> wrote:
% Hello everyone! i am checking a database due to some inconsintencies and
% i was wandering if its possible to find out the creation date of a
% record (using the oid, whatever...). Maybe i am saying something stupid
I'm currently getting:
"PgFoundry Could Not Connect to Database"
when I try to visit http://pgfoundry.org
Regards,
Ben
---(end of broadcast)---
TIP 6: explain analyze is your friend
Hi,
I have a program which uses Postgresql as a database for persistence.
The application uses IzPack to install.
Ideally I would like to also install Postgresql in the same wizard
conversation, plus get it up and running as a windows service (or
daemon on 'nix).
Is all of that possible - has an
Hi,
I need your help.
Here is my case: I would like to integrate postgresql
(binaries-no-installer) into my own installer for an python-based web
application in window systems (window xp, window 2000 etc). My own
installer needs to create some postgresql users, a database and tables
for the
Hi all,I have a question about how a certain function would look. Basically, what I want to do is having something that would take in a 'from' date (day, month, year) and a 'to' date (also day, month and year) and then spit back a series of records whose timestamps fall between those two dates. How
I have a column that I wish to use to designate loop
numbers.
A loop number is composed of a letter (F for flow, T for
temperatures etc.) followed by a sequence number starting at one and ending with
the last loop.
The loop numbers will appear as F-1, T-2 and so
on.
I seem to have no p
Joshua D. Drake wrote:
Training I agree with, but certifications can go either way.
Guys, a multiple perspective is important. Your perspective is valid,
but doesn't address the true purpose of these easy certs. They are
designed to give the companies involved larger mind space among
p
On Sun, Sep 03, 2006 at 12:59:08AM -0400, Tom Lane wrote:
> Michael Fuhr <[EMAIL PROTECTED]> writes:
> > test=> SELECT ARRAY[1, 2, 3, 4] @ ARRAY[1, 3];
> > ?column?
> > --
> > t
> > (1 row)
>
> > In 8.2 the above example will work in the stock installation for
> > arrays of any type (i.
First thanks to all for your immediate help!
2006/9/3, Tom Lane <[EMAIL PROTECTED]>:
"Peter Bauer" <[EMAIL PROTECTED]> writes:
> - OS: Debian Sarge with postgresql-7.4.7-6sarge1
You do know that we're up to 7.4.13 in that branch? There were some
pretty serious bugs found in 7.4 since 7.4.7, so
25 matches
Mail list logo
