On Thursday 25 Jul 2002 1:48 am, marc sturm wrote:
> Hello,
>
> Does anyone know how to convert a bigint into a date
> or timestamp in a SQL query.
> Thanks a lot.
The problem is that there is no cast from bigint=>interval directly AFAICT, so
go via text.
richardh=> select extract(epoch from no
On Wednesday 24 Jul 2002 3:12 pm, Peter Atkins wrote:
> All,
>
> I have two tables t_proj, t_task see below:
>
> CREATE TABLE t_proj (
> proj_id INT NOT NULL AUTO_INCREMENT,
> PRIMARY KEY (proj_id),
> task_id integer(12),
> user_id integer(6),
> title varchar(35),
> description varchar(80)
> );
>
I live in Guatemala, and our timezone is GMT -6, but my server (postgres 7.1
on a linux redhat 6.2) is storing the dates in the format
2002-07-24 00:00:00-04 ( I this understand represents GMT -4).
My linux servers gives me the the date and time correctly, so I know is not
a matter of the date o
Hi group,
i am currently learning PGSQL and having a question:
In DB1 i have got a table tbl1. In this table there are added, let's say 300
rows a day. Every time, rows are added, I want to Server to move these rows
to other DBs (DB2,DB3,DB4).
This seems not to work with Pl/Pgsql (or maybe I don
I am trying to insert a large object into my dbs
using: INSERT INTO table VALUES (lo_import ( ' z/image/image.jpg ' ));
but i get the message saying that I need superuser privilidges to do it and
that I should use client-side
\lo_import command.
Does anyone know how to use that command? And wha
You can do "show all" inside psql, which will show you all of your
current run time settings, including a line that should read "Time Zone
is unset" or whatever it is set to.
This isn't abundantly clear in the docs, so I'll add some notation
there, but if you check out
http://www.postgresql.org
select * from foo_table order by oid desc limit 1;
>From: Chris Ruprecht <[EMAIL PROTECTED]>
>To: "Leao Torre do Vale"
><[EMAIL PROTECTED]>,<[EMAIL PROTECTED]>
>CC: Jan Wieck <[EMAIL PROTECTED]>
>Subject: Re: [SQL] Last record
>Date: Wed, 24 Jul 2002 13:56:50 -0400
>
>Select * from where <..
Hello,
I need to make a view like:
create view view_test as select * from
mydb.mytable;
and I get this error:
ERROR: parser: parse error at or near "."
Whats the problem??
How can I solve this problem?
Thanks a lot,
Rogério Baldini
I have a weird problem and don't even know where to begin. First let
me explain what is going on.
I am developing on a Postgres 7.1.3 box and found this unexplainable delay
on this query
select * from webfinal where w_artistkey = 'MICBUR' order by w_date offset
2 limit 4;
I get at leas
