"Tom Lane" <[EMAIL PROTECTED]> writes:
> Now, because we surround the pattern with ^...$ anyway, I can't offhand
> see a use-case for putting $ with its regexp meaning into the pattern.
It's possible to still usefully use $ in the regexp, but it's existence at the
end means there should always be a way to write the regexp without needing
another one inside.
Incidentally, are these really regexps? I always thought they were globs.
And experiments seem to back up my memory:
postgres=# \d foo*
Table "public.foo^bar"
Column | Type | Modifiers
--------+---------+-----------
i | integer |
postgres=# \d foo.*
Did not find any relation named "foo.*".
> Comments?
The first half of the logic applies to ^ as well. There's no use case for
regexps using ^ inside. You would have to use quotes to create the table but
we could have \d foo^* work:
postgres=# \d foo^*
Did not find any relation named "foo^*".
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
