Re: [GENERAL] PHP and Postgres arrays

2008-01-18 Thread Yannick Warnier
Le vendredi 18 janvier 2008 à 23:10 +0100, Ivan Sergio Borgonovo a écrit : On Fri, 18 Jan 2008 23:01:09 +0100 Yannick Warnier [EMAIL PROTECTED] wrote: Hello, I've been searching (not very thoroughly, but still) for a way to get Postgres arrays right into PHP arrays, but it seems

[GENERAL] PHP and Postgres arrays

2008-01-18 Thread Yannick Warnier
than copy-pasting the user-proposed PHP functions? Thanks, Yannick Warnier [1] http://www.php.net/manual/en/ref.pgsql.php#58660 [2] http://www.perlmonks.org/?node_id=474518 ---(end of broadcast)--- TIP 6: explain analyze is your friend

[GENERAL] GiST and Gin technical doc

2006-10-01 Thread Yannick Warnier
Hi there, I'm having trouble finding technical documentation about GiST, Gin and TSearch2. I am particularly interested in the internal data structure of a GiST-ed or Gin-ed index, and the availability of searches by proximity. Does anyone know of a good place to find such doc, outside from the

Re: [GENERAL] People near me query

2004-03-19 Thread Yannick Warnier
Le ven 19/03/2004 à 11:05, David Garamond a écrit : Imagine an Orkut-like site. Suppose we have 'person' table of 100k people. About 75% of these people fill in their location (City/State/Country) information. We also have a 'city' table containing list of cities with their state country