Re: tablefunc extension - Mailing list pgsql-bugs

From Joe Conway
Subject Re: tablefunc extension
Date
Msg-id 523F7A86.9000305@joeconway.com
Whole thread Raw
In response to tablefunc extension  (Carl Clemens <Carl.Clemens@ctg.com>)
Responses Re: tablefunc extension  (Joe Conway <mail@joeconway.com>)
List pgsql-bugs
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 09/19/2013 12:24 PM, Carl Clemens wrote:
> The following query appears to be correct but fails to execute.

Your example is incorrect, however it is not clear (to me at least)
from your example what you are expecting as output -- please see the
documentation:

  http://www.postgresql.org/docs/9.2/interactive/tablefunc.html

If you still have a problem please provide SQL that can be cut and
pasted which:
1) create your table
2) insert sample rows
Then show us what out put you are trying to acheive as output from
that data.

Joe

- --
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iQIcBAEBAgAGBQJSP3qGAAoJEDfy90M199hljPoP/R/LPHwlkQYtIE9YjNS1FRoJ
viivrvUzAeP27zivgo8rIIrfXNyghUTfE8dyBRL1JB934PLcyu83+J9fcfW979xO
ogt2J4JJ3pctfOOm0cMdlYDarZPeo4VGXFQMe1K/7qMSZJGLUWbGwlR8pF2o/AGa
JdIMxwWuv6DwmU7yt8YnwWYRuyScUPyBFJCqntcrlfIDDlB313fdSUpu55c5/c89
Nq6+OGWScN9hA5AGm6AeucGEs8g3aNuevKN+AA6BN0D1wuo+pvkdK+iI9MlNyYlD
cB+i7+oluSb+UkNNcvz+PW0/3D0CJ12/nZfhOFsJCoplYzbuPJbZfI9eA/d9r8E3
YdDbN1/ofVAHLKx8Wy9LKqsGDb0pLFCTxc+jZhRkR87qf9qJ1OAb/DJHj7b9A0EC
/xy5LoxAFF61yGZjK9dPllF/asJcJkm3074G+hfCG5NdlJdOzshQ6eSNZqwOSTOM
6TPfQNTkpGmFfuuKRYTQjjAC+rUO6rfD+OIA+02rhYuRA1d7bxQw/tZvhOA9ZwvT
GVfpKHNnbG72euY8q9NMuamoImy1ivVdXkt1kkKKQkXi4UGwyRhS08Rf+JVfP5Zz
rNNtFp8lAo/eo5C3P5vFGUMr/4hcvjnPV71ZjgN4dG4Gp/HWdUsXn09TUrr1xV27
gcDhB2QFu+vbuP4yG/+N
=8/9U
-----END PGP SIGNATURE-----

pgsql-bugs by date:

Previous
From: jturkel@salsify.com
Date:
Subject: BUG #8464: Update with subquery with limit occasionally updates too many rows
Next
From: Joe Conway
Date:
Subject: Re: tablefunc extension