Hola a todos!!...
El día 22-07-2004 Gerardo Castillo escribió lo siguiente:
/
Hello,
I'm using PostgreSQL 7.4
I have a function wich use temporary tables. I read about temporary tables and they exists during the session.
But i have to call this f
On Tue, 2005-10-18 at 14:26 +, Adriana Marcela Aguirre wrote:
> Hola a todos!!...
Hi! :) That's a known postges 'problem', one which, I guess, every
pg-newbie encounters, especialy if he/she came from other RDBMSes. (I
personaly came from MSSQL).
> CREATE OR REPLACE FUNCTION "public"."f_test
Ignore my request. The solution is:
---
computeIfUptime() -
select (EXTRACT(EPOCH from TIMESTAMP 'now') - EXTRACT(EPOCH from TIMESTAMP
'2005-10-18 17:00:00'))::integer
-Original Message-
From: Lane Van Ingen [mailto:[EMAIL P
I have been trying to subtract two timestamps from each other to determine
the difference between the two timestamps (current time and a past timestamp
called 'updated_time') IN SECONDS, but no luck.
The trouble I am having is getting the first timestamp, representing the
current time, to translat
Hi All,
I have a small problem in using nested
transactions while working on Postgres 8.0.
Ex: I have a function A() which in turn
calls functions b() and c() , if i want commit something in b or c. i have to
use
start transaction read write;
-- set of sql statements and then say
com
PostgreSQL is 7.4.7.
My first table
CREATE TABLE tb_cat (
id INTEGER,
desc text
);
INSERT INTO tb_cat VALUES (10, 'cat10');
INSERT INTO tb_cat VALUES (20, 'cat20');
INSERT INTO tb_cat VALUES (30, 'cat30');
My second table
CREATE TABLE tb_array(
id INTEGER,
cat INTEGER[]
);
INSERT INTO tb_array V
how
can i do a query with 2 databases??
I believe int8(n.udf4) will do the trick for you.
- Original Message -
From: "Judith Altamirano Figueroa" <[EMAIL PROTECTED]>
To:
Sent: Friday, October 14, 2005 12:08 PM
Subject: [SQL] cast
> Hello I have a query that ran in 7.0.2, but in 8.0.1 does not, the query
> is the next:
>
>
Dear all,
I have a table created with this specifications:
CREATE TABLE cdr (
calldate timestamp with time zone NOT NULL default now(),
clid varchar(80) NOT NULL default '',
src varchar(80) NOT NULL default '',
dst varchar(80) NOT NULL default '',
dcontext varchar(80) NOT NULL default '
Andrew Hammond <[EMAIL PROTECTED]> wrote:
> So I need an end result that has entries for all days, even when
> there's nothing happening on those days, generate from a timestamped
> event table. I've already got the interesting entries. Now I need to
> fill the holes.
>
> To do this, I'm thinking
Hi
I want to know substitute function for sql server
ISNULL() function in postgre
Regards,Vikas Jadhav Codec
Communication Pvt. Ltd.Swargate, Pune.Ph: 020-2422 1460/70 (Ext
37)Email: [EMAIL PROTECTED]
Hi All,
We are having an opening for SQL-DBS for my CMM Level 5 Client in
Chennai
Skills : SQL-DBS
Exp : 1+yrs
Location : Chennai
Kindly send us your updated resume [EMAIL PROTECTED]
farzana@(at)shubhaminfo.(dot)com
In case you are interested, kindly send us the
following i
List,
I'm using the OFFSET / LIMIT combo in order to split up my query, so it
only parses 20 rows at a time (for my php-scripted webpage).
I'm using two queries; the first basically doing a select count(*) from
[bla bla]; the second grabbing the actual data while setting LIMIT and
OFFSET.
In a
Sri,
> I have a small problem in using nested transactions while
> working on Postgres 8.0.
This is a known problem with Postgres 8.0 - there is no support for
nested transactions (which occurs when calling functions). Your best bet
would be to raise an exception within B or C - this will cause
On Oct 13, 2005, at 21:50 , [EMAIL PROTECTED] wrote:
Dear all,
I have a table created with this specifications:
CREATE TABLE cdr (
calldate timestamp with time zone NOT NULL default now(),
clid varchar(80) NOT NULL default '',
src varchar(80) NOT NULL default '',
dst varchar(80) NOT N
[It's PostgreSQL, Postgres, or pgsql. It's never "postgre"]
On Oct 11, 2005, at 16:20 , Vikas J wrote:
Hi
I want to know substitute function for sql server ISNULL() function
in postgre
I'm not quite sure what the ISNULL() function does in SQL Server, but
it sounds like it might be similar
On Tue, Oct 18, 2005 at 03:38:54PM -0400, Lane Van Ingen wrote:
> select EXTRACT(EPOCH from TIMESTAMP current_timestamp) - EXTRACT(EPOCH from
> TIMESTAMP updated_time) ::integer
>
> ERROR: syntax error at or near "current_timestamp" at character 37
What are you intending "TIMESTAMP" to do? If y
Excuse me, how can I send a query to a file?, for example the result of
this query:
select id_articulo, articulo, color_code from articulos;
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choos
On Tue, Oct 18, 2005 at 06:03:59PM -0500, Judith Altamirano Figueroa wrote:
> Excuse me, how can I send a query to a file?, for example the result of
> this query:
>
> select id_articulo, articulo, color_code from articulos;
If you have a shell on a platform that supports input/output
redirection
On Oct 19, 2005, at 8:03 , Judith Altamirano Figueroa wrote:
Excuse me, how can I send a query to a file?, for example the
result of
this query:
select id_articulo, articulo, color_code from articulos;
You don't mention what client you're using. In psql, you can use
\o path/to/file.txt
F
On Tue, Oct 11, 2005 at 12:50:49PM +0530, Vikas J wrote:
> I want to know substitute function for sql server ISNULL() function in postgre
If you look in the index of the PostgreSQL documentation you'll
find an entry for ISNULL:
http://www.postgresql.org/docs/8.0/interactive/bookindex.html
If Pos
On Thu, 2005-10-13 at 10:31, Shavonne Marietta Wijesinghe wrote:
> how can i do a query with 2 databases??
This is only supported by an add on called dblink, and it's a little bit
klunky.
Could schemas solve your problem?
---(end of broadcast)---
T
Not sure if you got this figured out but I think
SELECT * from tb_cat WHERE id IN (SELECT
array_to_string(cat,',') as cat FROM tb_array WHERE
id=1);
is what your looking for?
--- paperinik 100 <[EMAIL PROTECTED]> wrote:
> PostgreSQL is 7.4.7.
>
> My first table
> CREATE TABLE tb_cat (
> id I
On Tue, Oct 18, 2005 at 08:09:48PM -0700, Matthew Peter wrote:
> Not sure if you got this figured out but I think
>
> SELECT * from tb_cat WHERE id IN (SELECT
> array_to_string(cat,',') as cat FROM tb_array WHERE
> id=1);
>
> is what your looking for?
I doubt it, considering that it doesn't work
[Please do not email me directly. Please post to the list so others
may help and benefit from the discussion.]
On Oct 19, 2005, at 14:30 , Vikas J wrote:
IsNull in sql server has syntax like isnull(column,substitute)
if "column" is null it shows value of "substitute". That can be
achieved
Judith Altamirano Figueroa wrote:
Excuse me, how can I send a query to a file?, for example the result of
this query:
select id_articulo, articulo, color_code from articulos;
if you mean psql
\o filename
and try to read output of a command \?
---(end of broadcast)---
Ya, I didn't test it.
The error message was expecting an integer not an
array, so coverting it to a list crossed my mind
'assuming' the subselect 'could' return a string of
integers for the IN clause.
Oh well. I'm glad there's people like you test it.
--- Michael Fuhr <[EMAIL PROTECTED]> wrote:
Correct me if I am wrong, but isn't COALESCE standard in this way?
Best Wishes,
Chris Travers
Metatron Technology Consulting
Michael Glaesemann wrote:
[Please do not email me directly. Please post to the list so others
may help and benefit from the discussion.]
On Oct 19, 2005, at 14:30 , V
28 matches
Mail list logo
