I guess that could need something like (untested)
delete from bigtable text_column !~ '^[0-9][0-9]*$';
HTH
Gerardo
- Mensaje original -
De: Suresh Raja suresh.raja...@gmail.com
Para: pgsql-general@postgresql.org, pgsql-...@postgresql.org
Enviados: Viernes, 27 de Marzo 2015 15:08:43
Hi all. I see an entire database, with all the stored procedures writen in
plpgsql. Off course, many (if not all) of that SP are simple inserts, updates,
selects and so on.
So, i want to test and show the differences between doing the same function in
pgpgsql vs. plain sql.
Im getting
Hi all. I see an entire database, with all the stored procedures
writen in plpgsql. Off course, many (if not all) of that SP are
simple inserts, updates, selects and so on.
So, i want to test and show the differences between doing the same
function in pgpgsql vs. plain sql.
Im getting