Yes, the system column "tableoid" identifies the actual table in which the
row is stored. If you cast this to "regclass" you'll get the name of the
table that the row is stored in:
SELECT tableoid::regclass FROM base_table;
There's more documentation on this available at
http://www.postgresql.org
Another way to match multiple occurrences is to use curly brackets with a
number, like:
select 'ab' ~ '^[a-z]{2}$';
It can be done with a range of numbers as well:
select 'ab' ~ '^[a-z]{2,4}$';
select 'abab' ~ '^[a-z]{2,4}$';
I believe, however, that the curly brackets notation was introduced in
t to users cleanly. The array_to_string function may
help you make it easier to display the results.
http://www.postgresql.org/docs/8.4/static/functions-array.html#ARRAY-FUNCTIONS-TABLE
Hope this helps,
--Stephen Belcher
On Mon, Feb 22, 2010 at 12:05 PM, Rob Sargent wrote:
> My mistake.
