2013/2/2 Pavel Stehule <pavel.steh...@gmail.com>: > 2013/2/2 <haman...@t-online.de>: >> Pavel Stehule wrote: >> >>>> >>>> but maybe https://github.com/dimitri/prefix can help >>>> >> >> Hi Pavel, >> >> thanks - this works perfect. However, it does not seem to play well >> with the optimizer, so I ended up with >> >> select all candidates into a temp table using prefix operator >> apply all other conditions by joining that temp table to original ones >>
seriously - it is typical solution - and it is great so PostgreSQL help to you :) Regards Pavel > > you can send proposals to enhancing to Dimitry - He will be happy :) > > Regards > > Pavel > >> Regards >> Wolfgang >> >> >> >> -- >> Sent via pgsql-general mailing list (pgsql-general@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
