File: parallel.sql

package info (click to toggle)
plr 1%3A8.4.8.2-1
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 1,180 kB
  • sloc: ansic: 4,741; sql: 640; sh: 357; makefile: 78; perl: 20
file content (9 lines) | stat: -rw-r--r-- 309 bytes parent folder | download 
1
2
3
4
5
6
7
8
9
 
CREATE TABLE my_table (my_column text);
INSERT INTO my_table (my_column) SELECT md5(generate_series(1, 1000000, 1)::text);
CREATE OR REPLACE FUNCTION my_value()
    RETURNS numeric
    LANGUAGE 'plr'
AS $BODY$
    return(1000)
$BODY$;
SELECT * FROM my_table WHERE my_column LIKE '%12345%' order by my_column;