Hi Michael,
Yes, I understand this but, I would like to have the results of both
"table1.name, table2.name"
sorted as one column.
Is this possible?
Thanks,
Andy
-Original Message-
From: Michael Glaesemann [mailto:[EMAIL PROTECTED]
Sent: Friday, January 02, 2004 8:40 PM
To:
Title: Message
Hi
All,
Is it possible to
sort by two columns? Using the query below?
SELECT table1.name,
table2.name, FROM table1, table2 WHERE
table1.id = table2.id ORDER BY
I want to be able to
sort the names select from two different tables and two different colums(same
data type)
I would have to agree with EMS-HiTech's product also. A feature rich,
product, very responsive tech support/bug report. PGManager beats the
competition hands down.
Andy
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Rich Hall
Sent: Wednesday, December 3
Thanks All for your suggestions, I have enough information to construct
what I need.
-Original Message-
From: Michael Fuhr [mailto:[EMAIL PROTECTED]
Sent: Friday, December 26, 2003 8:43 PM
To: Andy Lewis
Cc: [EMAIL PROTECTED]
Subject: Re: [SQL] Radius of a zip code
On Fri, Dec 26, 2003
Title: Message
Hello
all,
I was trying to find
all zip codes within a given zip code or radius.
I have map points
and Latitude and Longitude in my zip table.
I remember
seeing a post or two referencing this but can't see to find
it.
I've tried the
following with no luck:
-- 20
M
Thanks Tom, worked like a charm.
Appreciate your time on Christmas day!
Best Regards and Merry Christmas to all.
Andy
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 25, 2003 10:44 AM
To: Andy Lewis
Cc: [EMAIL PROTECTED]
Subject: Re: [SQL] Point
Title: Message
Hello all merry
XMAS!
I'm trying to create
a function that will return a point and having little luck in returning
results.
Basically I have a
zip code DB complete with city, state and zip pre-populated.
What I would like to
do is create this function:
CREATE OR REPLACE
