Hi,
I've to retrieve some addresses from a dirty database, sometimes the same
address is written in such a different way for axample:
george washington avenue n 44
I can find:
g. washington avenue
washington avenue
g. washington av.
wHashington avAnue ( in case of error)
etc.
I'd like to
Hi to all,
I need help about the following issue:
in my db I've three table which have the same column (there are some reasons
for that) I'd like to perform a select statement like that: select my_column
from xxx_table .
Where xxx could be choosen from another table result.
for example :
select
Hi,
I've to perform a where condition which includes the output from a
multiselectio pop-up: ie user can choose one or more item from a pop-up
munu, let's say (item1,item3,item10), then I want to send this set of
values
as an array or table via php to a query that should have as where
Hi
I need to set a query which performs a intersection check between two set
of
polygons which are stored into two tables.
I wrote the where instruction so:
...
where area(intersection(t1.the_geom,t2.the_geom))0
...
The results are ok, but the query is too slow. I tried to applay a
Hi
I need to set a query which performs a intersection check between two set of
polygons which are stored into two tables.
I wrote the where instruction so:
...
where area(intersection(t1.the_geom,t2.the_geom))0
...
The results are ok, but the query is too slow. I tried to applay a GIST and
gtree
Hi,
I've to perform a where condition which includes the output from a
multiselectio pop-up: ie user can choose one or more item from a pop-up
munu, let's say (item1,item3,item10), then I want to send this set of values
as an array or table via php to a query that should have as where condition
Hi Medi,
Last night, I wrote a function which perfoms a subset of queries and returns
the results of a temporary table. It's more fast than I believe and that's
ok to me.
There is a prolem : It works too fine. I'm afraid of Murphy's law. I red
into the Internet that there are problem when there
Hi all,
I use Postgresql 8.2 in win env. I wrote a set of complex queries which
return three temporary tables of results. I want to use then in php, but the
unique way I know consists on sending one query a time via php, the logic I
need has now been cablated into the sql code.
I could use the
Hi,
I need to implement a filter in order to select from the first table the
second one...
it could be simple, but i'm wasting time. Please, is there anyone could help
me?
thanks in advance
Giu
c1 c2 c3 c4 c5
1)133659;1;0039;00121;7
2)133664;1;0039;00121;12
3)133664;2;0039;00121;12
Hi all,
I agree, but now I actually need a technical and syntactical support in
order to grab all my queries to keep the php code simple and fast. This is
the scenario:
I send as input three parameters: x,y,z (one or two could be null)
1th query on human anagrafic table(S) regarding x,y,z -
Thanks for the suggestion,
I was studying a solution which foresees the 'case when' construct...
now I can use it in addition to array_to_string . In fact my solution
failed too if it's raining cats and dogs :-) , but if there are some more
values I get them all as well.
thanks
Help,
alfter my computer chrashing, when I try to read a table by using pgAdmin I
get the following errors:
could not open relation 1663/16525/2604
could not open relation 1663/16525/2611
could not open relation 1663/16525/2604
after that if I push ok I can see the data in the tables
I see in the
--
Email.it, the professional e-mail, gratis per te: http://www.email.it/f
Sponsor:
Logos Finanziaria SPA. Società di credito ad erogazione diretta. Fino a
30.000 euro in 24 ore! Clicca e scopri come
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=2909d=20061125
Hi,
hope to not be OT. I'm trying to install PostGresql into a virtual sever,
I've set the ConnectionName = Console as suggested. In the shell and by
using the same shell I start the installer .msi of 8.2.1 verision, but after
the third step I get the error the postgresql installer must be run on
Hi Lane,
when I've imported my first dbf table by using db2pg.exe, I tought to obtain
a sql modifiable script which I could use to import the table. The table is
automatically imported with the feature without OIDS. For this reason
I've to use your solution. Thanks a lot.
Peraphs, because of
Hi Guys,
I'm a newbie in Postgres and hope my mail is not off topic. Well, I'm
migrating from Mysql to PostGree in order to use the postgis features. I've
some dbf files I've to import, so I've used the utility dbf2pg.exe ( I've
installed the version 8.1 in win xp env). Now is there a way to add
16 matches
Mail list logo
