On the other end of the spectrum there are many addresses with only one
entry. When I use one of these addresses in the WHERE clause it takes
just as long as the address with 150k rows. If the sequential scan is
better for 150k rows out of 800k rows, what about 1 out of 800k? It
seems that
I'm moving to PostgreSQL from MS SQL Server. In MSSQL I usually create
stored procedures to return result sets based on the passed arguments.
I guess my question is: Is it possible to return multi-row data from
the PL/PGSQL functions of Postgres? It's rather easy to just return
one field f
