Re: Query to get the "next available" unique suffix for a name

> 4) Do a SELECT on each row that starts with "MikeChristensen" and then
> trying to append the row count to the end, this might not be exact but
> it's somewhat intelligent as a starting point.  However, this might
> require some special indexes on this table to quickly scan rows that
> start with a certain name.  However, if I get to the point where this
> becomes slow then I can worry about it at that point since this would
> only be run on new account creation and not super speed critical.
>

CREATE TABLE test (a text PRIMARY KEY);

INSERT INTO test (a)
SELECT * FROM (SELECT 'MikeChristensen' || generate_series AS t FROM
generate_series(1,10000)) x
WHERE t NOT in (SELECT a FROM test) LIMIT 1 RETURNING *;

Groeten, Arjen