hello
SELECT ('3600'::int::abstime-'epoch'::abstime)::interval;
try to modify this idea to fit your purpose.
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
Title: RE: [SQL] Regex
Thanks Tom,
I attacked the issue another way which appears to work...
I used :
explain select * from nodes left join node_names on node_names.node_id = nodes.node_id
which returned :
query
QUERY PLAN
Theo Galanakis <[EMAIL PROTECTED]> writes:
> Basically the regex should return TABLEA, TABLEB from:
> Select *
> from TABLEA
> Inner jon TABLEB on tableb.columna = tablea.columna
You realize of course that this problem is mathematically impossible?
Regexes are less powerful than context-free gra
Hello,
Now i am working on Linux database server/Windows Client project.
I have a doubbt. How to take DB backup from my windows client machine
where DB is intsalled at linux server. pg_dump doen't works from
windows client butr its working from local server machine. How to
rectify the problem.
Title: Regex
I know this is not a regex forum, however I had great assistance last time and thought I would ask, since the regex is looking through an SQL statement.
I was trying to parse a SQL statement and get all the tables used. I'm actually doing this in Cold Fusion.
I have gone as far
--- Kent Anderson <[EMAIL PROTECTED]> wrote:
> I am attempting to use a stored procedure to pull a
> report from the
> database. My questions is if its even possible to
> pull the data using a
> function and then treat the returned data as a
> normal recordset with the web
> pages.
>
> The actua
I am attempting to
use a stored procedure to pull a report from the database. My questions is if
its even possible to pull the data using a function and then treat the
returned data as a normal recordset with the web pages.
The actual function
looks like
CREATE OR REPLACE
FUNCTION submi
On Tue, Oct 05, 2004 at 05:37:51PM +0200, Silke Trissl wrote:
> CREATE or replace FUNCTION mylog_test(integer, varchar) RETURNS
> timestamp AS '
> DECLARE
> n ALIAS FOR $1;
> logtxt ALIAS FOR $2;
> curtime timestamp;
> BEGIN
> curtime := ''now'';
>
Silke Trissl <[EMAIL PROTECTED]> writes:
> I expected, that the variable curtime gets a new time value, each time
> the function is called (at least that is what I understood from the
> documentation). This works fine, if I test it with
> SELECT mylog_test(5, 'test');
> But as soon as I call the
Hi,
I am using PostgreSQL 7.4 and was trying to log the time each part of a
function needs. I found a pretty helpful bit of code in the documentation:
http://www.postgresql.org/docs/7.4/static/plpgsql-expressions.html
I used the following function, called inside the another function:
CREATE or re
> How does dns_ptr relate to other data? Depending on what you're
> doing, other ways of organizing your tables might also make sense.
These are actually DNS servers authoritive for a domain that is stored
in a VARCHAR() in the same table.
After sleeping on it, I think using an array is indeed
try :
resend_interval * '1 seconds'::interval
this will convert your seconds into an interval.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
O Erik Wasser έγραψε στις Oct 5, 2004 :
> Hi List,
>
> I got a table named foobar with two fields
>
> last_sms is a 'timestamp without timezone'
> resend_interval is a 'integer'
>
> I choose 'integer' for resend_interval rather than a 'interval' because
> the frontend can easier handle
Hi List,
I got a table named foobar with two fields
last_sms is a 'timestamp without timezone'
resend_interval is a 'integer'
I choose 'integer' for resend_interval rather than a 'interval' because
the frontend can easier handle the number of seconds. But now I'm stuck
with the query t
On Mon, Oct 04, 2004 at 10:56:20PM -0500, C. Bensend wrote:
>
>I have a table with the following columns:
>
> dns1_ptr | inet | default '0.0.0.0'::inet
> dns2_ptr | inet | default '0.0.0.0'::inet
> dns3_ptr | inet | default '0.0.0.0'::inet
> dns4_
15 matches
Mail list logo
