Sql

Search

do block in postgresql

do $$ 
<<first_block>>
declare
  film_count integer := 0;
begin
   -- get the number of films
   select count(*) 
   into film_count
   from film;
   -- display a message
   raise notice 'The number of films is %', film_count;
end first_block $$;
Code language: PostgreSQL SQL dialect and PL/pgSQL (pgsql)

Comment

PREVIOUS	NEXT

Code Example
Sql :: mysql pass command from command line
Sql :: create directory in sql server
Sql :: oracle INTERVAL DAY to second to number
Sql :: select query in mongodb
Sql :: create user with encrypted password postgresql
Sql :: mysql row generator
Sql :: plsql find location of procedure
Sql :: how to avoid duplicate records in sqlite
Sql :: insert into table using openquery
Sql :: postgresql inheritance
Sql :: java.sql.sqlexception: the url cannot be null
Sql :: oracle sql trigger select into
Sql :: mysql create view
Sql :: find current server name for SSMS
Sql :: cross join sl
Sql :: description query in sql
Sql :: sql convert int to string
Sql :: mysql regex select
Sql :: Insufficient memory to excute the sql query
Sql :: show create table in postgresql
Sql :: local pg_sql to heroku pg_sql
Sql :: sqlalchemy query join many to many
Sql :: sql queries practice
Sql :: create table
Sql :: desc sql
Sql :: on update cascade
Sql :: new rails app with mysql
Sql :: sql server in python
Sql :: get full yearr data omonthwuse sql
Sql :: sqlite column

Search

SQL

do block in postgresql

ADD CONTENT