its second parameter type is either varchar and
char(3), but those still require a cast in the WHERE-clause of the
query. I've also tried anyelement, but that does not work even with a
cast.
Thank you,
--
Adam Mackler
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
e defining all
possible cominations, which even in this limited example would be 26^3
values? I just used three uppercase letters (and case-insensitive
matching) as an example. In my actual application I have twelve
characters and the operator function is doing more advanced
regular-expression matching.
Thanks again,
--
Adam Mackler
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
n between two
data types,' that the meaning of "data type" includes only those
created using 'CREATE TYPE' and excludes domains. If I am mistaken on
that point I would be grateful to learn of that mistake.
Thanks again,
--
Adam Mackler
--
Sent via pgsql-general mailing li
s "point_add()" function? I know I could ask
that project's developers to change the function's name, but that
could break other code that currently uses it, and even if it didn't,
I would prefer something less intrusive on that project.
Thanks very much for any ideas ab
PostgreSQL.
Thank you for the response and insight.
--
Adam Mackler
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
there a
way to get pg_dump to output the necessary statements such that
running the dump back through psql results in the same priviliges that
I started with?
I am using version 9.5.6.
Thanks very much,
--
Adam Mackler
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
O clarifies the specifics of what I'm trying to. It
seems like there ought to be a way, but I haven't figured it out.
Thanks very much.
--
Adam Mackler
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thu, Oct 10, 2013 at 10:42:47AM -0700, David Johnston wrote:
> Adam Mackler-3 wrote
> > http://stackoverflow.com/questions/19237450/can-sql-view-have-infinite-number-of-rows-repeating-schedule-each-row-a-day
> >
> Not sure how you can state "But I'm willing to
O clarifies the specifics of what I'm trying to. It
seems like there ought to be a way, but I haven't figured it out.
Thanks very much.
--
Adam Mackler
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
variable
name, what factors should I be thinking of while deciding whether to
store my self-composed, multi-hundred-line long SQL statement as a
view or a function?
--
Adam Mackler
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http:
able names
with the schema name.
Am I correct in concluding that there's no way to have a single view in the
public schema that selects data from tables in different other schemas
depending on my search_path at the time I execute a query involving that
view?
Thanks.
--
Adam Mackler
11 matches
Mail list logo
