I guess that could need something like (untested)
delete from bigtable text_column !~ '^[0-9][0-9]*$';
HTH
Gerardo
- Mensaje original -
> De: "Suresh Raja"
> Para: pgsql-general@postgresql.org, pgsql-...@postgresql.org
> Enviados: Viernes, 27 de Marzo 2015 15:08:43
> Asunto: [SQL] chec
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 statistic
> 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 gettin
