Hi Ryan,
There is a bit of a strange way around the distance overhead issue :
Create another table with structure like
(lat1,long1,zip1,lat2,long2,zip2,distance)
and precalculate the distance for each possibility. This means n*(n-1) rows
if you have n location rows. You would then include thi
"Josh Berkus" <[EMAIL PROTECTED]> writes:
> Er... what were you expecting, exactly?
AFAICT, the quoted behavior is correct per the defined behavior of
nullif(), cf
http://www.ca.postgresql.org/users-lounge/docs/7.1/postgres/functions-conditional.html
NULLIF(value1, value2)
The
On Sat, 28 Jul 2001, Roy Souther wrote:
> In PG the _ is a wildcard that means any singal char. I need to do a search
> for the actual _ char and not get back thousands of wrong matches. Is there
> and escape char that I could use? This needs to work with PG 7.0.3 & 7.1.2.
\\_ should work for
In PG the _ is a wildcard that means any singal char. I need to do a search
for the actual _ char and not get back thousands of wrong matches. Is there
and escape char that I could use? This needs to work with PG 7.0.3 & 7.1.2.
TIA
--
Roy Souther <[EMAIL PROTECTED]>
01100010 10101110 11000110
On Fri, 27 Jul 2001, [iso-8859-1] María Elena Hernández wrote:
> Is it possible to get thecoluns names of an a table in the database with a sql
> query??
"psql -E" will show the SQL commands that psql internally uses to display
tables, database, etc. Once in psql, use "\d table_name" to see fie
Hi
everybody! Is it possible to get thecoluns names of an a
table in the database with a sqlquery?? Thanks, a lot.
e-mail[EMAIL PROTECTED][EMAIL PROTECTED]
