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
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
Nick Stone wrote:
> Hope this helps
>
> SELECT
> *
> FROM
> speed_history as outside etc..
> WHERE
> (speed = (
> SELECT
> speed
> FROM
> speed_history as inside etc..
> WHERE
>
> 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 <---
>
Hope this helps
SELECT
*
FROM
speed_history as outside etc..
WHERE
(speed = (
SELECT
speed
FROM
speed_history as inside etc..
WHERE
(outside.interface = i
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
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
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 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;
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
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
[SQL] unsubscribe
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
12 matches
Mail list logo
