On Thu, 8 Apr 2004, yek ching wrote:
> Dear Sir/Miss,
>
> Is there a way to do a multi-database select query??.. I fail to find the
> related solution... currently i i created seperate table call stockmaster
> under seperate database for each seperate organizations... When i want to
> queries
On Fri, 2004-04-09 at 18:43, Greg Stark wrote:
> Josh Berkus <[EMAIL PROTECTED]> writes:
>
> > Rod,
> >
> > > Something along the lines of the below would accomplish what you want
> > > according to spec. ROW_NUMBER() is a spec defined function. (6.10 of
> > > SQL200N)
> >
> > Great leaping litt
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Christina Zhang wrote:
> Hello,
>
> We are planning to use Crypt() to encrypt the application level
> users' passwords. Our question is that which encryption method
> the Crypt() is using? (DES, or some other encryption algorithms?)
> Because we concern about the strenth of the Crypt().
Use MD5.
Hi Sir,
I am attaching a document with this file showing two table.. <>
It consist of two table VALUE AND VALUE_TYPE..
when i have value_type_id=1 i must get Value_varchar column value
when i have value_type_id=2 i must get Value_int column value
Please send a SQL query for this...
I want to
Dear Sir/Miss,
Is there a way to do a multi-database select query??.. I fail to find the
related solution... currently i i created seperate table call stockmaster
under seperate database for each seperate organizations... When i want to
queries out the stock item qty for multi database, i face
Ok. I found the libpq syntax for COPY in the Programmer's manual. I've
got a working version, but wanted to verify something.
PQexec(conn, "COPY foo FROM STDIN");
PQputline(conn, "3\thello world\t4.5\n");
PQputline(conn,"4\tgoodbye world\t7.11\n");
...
PQputline(conn,"\\.\n");
PQendcopy(conn);
1.
Hello,
We are planning to use Crypt() to encrypt the application level users' passwords. Our
question is that which encryption method the Crypt() is using? (DES, or some other
encryption algorithms?) Because we concern about the strenth of the Crypt().
Thanks for your input.
Christina
--
Hi.
I have a (simplified) table layout like this:
+-+ +-+
| sub_a | +--+ | sub_b |
+-+ | main | +-+
| id | +--+ | id |
| main_id |
I understand I can use the function to_date(s,f) for converting a string
into a date using a non-standard format.
I'm wondering if there is a way to set a non-standard date format for
the duration of a session, something like the "ALTER SESSION SET
NLS_DATE_FORMAT='f'" Oracle statement.
Thank you.
??
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 07, 2004 12:46 PM
Subject: Unknown Exception ([EMAIL PROTECTED])
>
> Mail Transaction Failed - This mail couldn't be converted
>
> - failed message -
> d9H_,ac,IAdU'Qha
I'm attempting to use the COPY command through the libpq C functions.
In the psql command line editor, I'd have the following commands:
COPY testtable FROM stdin WITH DELIMITER ',';
1, 2, 'a', 3, 4
5, 6, 'b', 7, 8
9, 10, 'c', 11, 12
\.
My question is:
Does this all have to be passed as one big
Josh Berkus <[EMAIL PROTECTED]> writes:
> Rod,
>
> > Something along the lines of the below would accomplish what you want
> > according to spec. ROW_NUMBER() is a spec defined function. (6.10 of
> > SQL200N)
>
> Great leaping little gods! They added something called "row number" to the
> spe
James Robinson <[EMAIL PROTECTED]> writes:
> Given a reference to id=3, would a recursive query be the trick to
> unrolling the list to discover id=1 as the head using a SQL one-liner?
I think you could do it, but don't have the syntax in my head.
> would any potential recursive query implement
James,
> Would recursive queries be the trick to doing things like unwinding a
> linked-list to either the head or tail, with:
Yes. Also check out contrib/ltree and contrib/tablefunc in your handy-dandy
PostgreSQL source code.
--
Josh Berkus
Aglio Database Solutions
San Francisco
---
Rod,
> Something along the lines of the below would accomplish what you want
> according to spec. ROW_NUMBER() is a spec defined function. (6.10 of
> SQL200N)
Great leaping little gods! They added something called "row number" to the
spec?
Boy howdy, folks were right ... the ANSI committee r
Would recursive queries be the trick to doing things like unwinding a
linked-list to either the head or tail, with:
create table list (
id int primary key,
parent int references list(id)
);
insert into list values (1, null); -- head of
Dear Tom,
I didn't get your replies, but found them in the archives.
Thanks a lot, the patched 7.4 works with the original query!
(didn't patch 7.3 since it's a production db, and it works in 7.3 anyway)
Thanks again,
Yours,
G.
%--- cut here ---%
\end
---
18 matches
Mail list logo
