[SQL] unsubscribe
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
It seems to me that I should be able to do this, but after 5 hrs of trying,
I
can't figure this one out.
I could do this in two queries, but seems like I should be able to do this
in
one. What I am trying to do:
Find the highest speed at which each interface of a router has run over
time.
I have
hello
I' trying to catch un update that fails to update because no row matchs
the where clause:
for instance:
update t set c=1 where cc=2;
--and no row with cc=2
I would like to perform a
insert into t (c) values 1;
before the update is resolved
I hoped a trigger before update could help me, bu
On Fri, Aug 12, 2005 at 05:13:24PM +0200, santiago wrote:
> hello
>
> I' trying to catch un update that fails to update because no row matchs
> the where clause:
>
> for instance:
> update t set c=1 where cc=2;
> --and no row with cc=2
>
> I would like to perform a
> insert into t (c) values 1;
Hi,
I'm running Postgresql-8.0 for the database, using cygwin and PostgreSQL 7.4.5 compiled lib.
When I tried to encrypt some data by calling encrypt() function, I'm getting blank returns to me from the encrypt function. I'm not sure I'm using the encrypt() function incorrectly or is it Postgr
On 8/12/05 11:09 AM, "Lane Van Ingen" <[EMAIL PROTECTED]> wrote:
> It seems to me that I should be able to do this, but after 5 hrs of trying,
> I
> can't figure this one out.
>
> I could do this in two queries, but seems like I should be able to do this
> in
> one. What I am trying to do:
> Find
Greetings,
I have the following join, and in this join I am getting all of the
data except that which joins the pa table to the dao table. When I
try to join it using a left join, i get all of the data except this
table. When I use a right join, I get nothing at all. If I make
this a s
Hope this helps
SELECT
*
FROM
speed_history as outside etc..
WHERE
(speed = (
SELECT
speed
FROM
speed_history as inside etc..
WHERE
(outside.interface = i
> Data in speed history looks like this:
> interface_id updated_time speed
> 1 2005-08-11 08:10:23 450112
> 1 2005-08-11 10:53:34 501120 <---
> 1 2005-08-11 10:58:11 450112
> 2 2005-08-11 08:10:23 450112 <---
>
Nick Stone wrote:
> Hope this helps
>
> SELECT
> *
> FROM
> speed_history as outside etc..
> WHERE
> (speed = (
> SELECT
> speed
> FROM
> speed_history as inside etc..
> WHERE
>
On Fri, Aug 12, 2005 at 18:57:34 +0100,
Nick Stone <[EMAIL PROTECTED]> wrote:
> Hope this helps
>
> SELECT
> *
> FROM
> speed_history as outside etc..
> WHERE
> (speed = (
> SELECT
> speed
> FROM
> speed_hi
Please keep replies posted to the list unless you have a specific reason
not to.
On Fri, Aug 12, 2005 at 14:56:54 -0700,
Jeff Lu <[EMAIL PROTECTED]> wrote:
> I can't see why it's returning (null).
>
> sprintf(query_string, "INSERT INTO mytable values('%s', '%s')", key, ,
> encrypt('hello w
12 matches
Mail list logo
