upqNsgng

1SELECT email FROM users WHERE name = '" + name + "'
2Commit
3Commit
4Commit
5Commit
6Commit
7Commit
8SELECT * FROM users;
9SELECT * FROM proyecto ORDER BY numvisitas DESC LIMIT 3;
10SELECT * FROM proyecto ORDER BY valoracionTotal DESC LIMIT 10;
11SELECT proyecto_nombre,COUNT(*) FROM comentario GROUP BY proyecto_nombre;
12SELECT p.nombre,p.fechacreacion,p.fechaultimamod,p.numvisitas,p.imagen,p.privacidad,p.valoracionTotal,p.descripcion,p.administrador FROM proyecto p, (SELECT proyecto_nombre,COUNT(*) cuenta FROM comentario GROUP BY proyecto_nombre) t WHERE p.nombre=t.proyecto_nombre ORDER BY cuenta DESC LIMIT 10;
13INSERT INTO PREFS VALUES ('scheduler_running','0')
14DROP TABLE IF EXISTS IPOLIST
15DROP TABLE IF EXISTS USERLIST
16SELECT * FROM test WHERE name LIKE 't%'
17SELECT * FROM fchans()
18SELECT protocol,chan_name,id FROM fullchan WHERE is_current=1
19SELECT id,label FROM sys order by id
20SELECT ARRAY(SELECT access FROM caccess_type WHERE savable)
21SELECT protocol, cur_chan_name, id from fullchan WHERE is_current ORDER BY dev_id,chan_id
22SELECT name from modemark ORDER BY id
23SELECT firstname, lastname, email FROM users WHERE firstname LIKE %s OR lastname LIKE %s OR email LIKE %s;", (data + "%", data + "%", data + "%
24SELECT * FROM apps
25SELECT * FROM apps WHERE valid
26SELECT * FROM apps WHERE NOT valid
27select * from apps WHERE packagename=" + "'" + app + "'
28select * from apps WHERE packagename=" + "'" + app + "'
29select max (counts) from clock;
30select max (counts) from clock;
31select max (counts) from clock;
32select max (counts) from clock;
33select max (counts) from clock;
34select max (counts) from clock;
35select count(*) from acl;
36select count(*) from tacl;
37CREATE INDEX state_index ON homeless_by_coc(state)
38CREATE INDEX count_index ON homeless_by_coc(count)
39SELECT * from users
40SELECT email from users
41SELECT email, username, password, is_driver, is_admin from users;
42SELECT email, username, password, is_driver, is_admin from users
43DELETE from users where email = '" + str(email) + "'
44SELECT email, username, password, is_driver, is_admin from users
45UPDATE users set username = '" + username + "' where email = '" + email + "'
46SELECT email, username, password, is_driver, is_admin from users
47UPDATE users set is_admin = '" + '1' + "' where email = '" + email + "'
48SELECT email, username, password, is_driver, is_admin from users
49UPDATE users set password = '" + password + "' where email = '" + email + "'
50SELECT ride_id, route, driver, time, request from rides
51SELECT ride_id, route, driver, time, request from rides
52SELECT id, username, pickup_point, time, accept from request
53SELECT id, username, pickup_point, time from request
54UPDATE request set accept = '" + '1' + "' where id = '" + str(ride_id) + "'
55SELECT ride_id, route, driver, time, request from rides
56UPDATE rides set driver = '" + driver + "' where ride_id = '" + str(ride_id) + "'
57SELECT ride_id, route from rides
58UPDATE rides set route = '" + route + "' where ride_id = '" + str(ride_id) + "'
59SELECT ride_id, route, driver, time, request from rides
60UPDATE rides set time = '" + time + "' where ride_id = '" + str(ride_id) + "'
61SELECT ride_id from rides
62DELETE from rides where ride_id = '" + str(ride_id) + "'
63SELECT table_name FROM information_schema.tables ORDER BY table_name
64SELECT table_name FROM information_schema.tables WHERE table_schema='public' ORDER BY table_name
65SELECT table_name FROM information_schema.tables WHERE table_schema='public'
66SELECT table_name FROM information_schema.tables WHERE table_schema='public'
67SELECT oid, typname FROM pg_catalog.pg_type
68SELECT * FROM users;
69show client_encoding
70show client_encoding
71select oid, office_descr from geousers.offices
72select fid, floor_descr from geousers.floor
73select did, duties_descr from geousers.duties
74select tid, title_descr from geousers.titles
75select oid, office_descr from geousers.offices
76select fid, floor_descr from geousers.floor
77select did, duties_descr from geousers.duties
78select tid, title_descr from geousers.titles
79""SELECT * FROM irregular_verbs;""
80SELECT table_name FROM information_schema.tables ORDER BY table_name
81SELECT table_name FROM information_schema.tables WHERE table_schema='public' ORDER BY table_name
82SELECT table_name FROM information_schema.tables WHERE table_schema='public'
83SELECT table_name FROM information_schema.tables WHERE table_schema='public'
84SELECT oid, typname FROM pg_catalog.pg_type
85SELECT drzava, count(*) FROM plezalisca GROUP BY drzava ORDER BY drzava
86SELECT nekoime.plezalisce, drzava, stevilo FROM nekoime JOIN plezalisca ON nekoime.plezalisce=plezalisca.plezalisce ORDER BY drzava, plezalisce
87SELECT smer FROM smeri
88SELECT version();
89SELECT * from teams;
90SELECT * from teams WHERE team_id="+str(id)+";
91SELECT * from teams WHERE name='"+name+"';
92SELECT * from teams WHERE abbreviation='"+abbreviation+"';
93SELECT * from players WHERE team_id='"+teamid+"';
94SELECT * FROM players WHERE name='"+name+"' AND position='"+position+"' AND team_id="+str(teamid)+";
95SELECT * from players WHERE player_id='"+playerid+"';
96SELECT * from players WHERE name='"+playername+"';
97SELECT * from rankings WHERE player_id='"+playerid+"';
98SELECT * from game_log WHERE player_id='"+playerid+"';
99SELECT * from fantasy_stats WHERE player_id='"+playerid+"';
100select q7()
101select q8()
102""SELECT count(*) FROM problems;""
103""SELECT uid,pid from solved;""
104""SELECT uid,userid FROM users;""
105""select pid, 'http://' || contestid || '.contest.atcoder.jp/tasks/' || problemid as url, title from problems left join contests on problems.cid = contests.cid;""
106SELECT * FROM test WHERE name LIKE 't%'
107SELECT * FROM score ORDER BY score DESC LIMIT 10;
108SELECT COUNT(*) FROM pg_database WHERE datallowconn='t';
109SELECT datname FROM pg_database WHERE datallowconn='t';
110DROP SCHEMA IF EXISTS pglogical CASCADE
111CREATE TEMP TABLE " + temp_table + " (content text)
112SELECT * FROM " + temp_table + ";
113DROP OWNED BY " + username + " CASCADE
114select * from c_stats where p_name =  'Rafael Nadal'
115select * from ranking_t")#select * from c_stats where p_name =  request.POST.get("sqlQuery", "
116select * from c_stats where p_name =  'Rafael Nadal'
117select * from ranking_t where rank = "+var)#select * from c_stats where p_name =  request.POST.get("sqlQuery", "
118select * from c_stats where p_name =  'Rafael Nadal'
119select * from ranking_t where p_name = "+"'"+var+"'")#select * from c_stats where p_name =  request.POST.get("sqlQuery", "
120select * from c_stats where p_name =  'Rafael Nadal'
121select * from tournament_g where t_name = "+"'"+var2+"'"+" and year = "+"'"+var3+"'"+" and p_name = "+"'"+var1+"'")#select * from c_stats where p_name =  request.POST.get("sqlQuery", "
122select * from c_stats where p_name =  'Rafael Nadal'
123select * from tournament_g where t_name = "+"'"+var1+"'"+" and year = "+"'"+var2+"'")#select * from c_stats where p_name =  request.POST.get("sqlQuery", "
124select * from c_stats where p_name =  'Rafael Nadal'
125select * from h2h where p1_name = "+"'"+var1+"'"+" and p2_name = "+"'"+var2+"'")#select * from c_stats where p_name =  request.POST.get("sqlQuery", "
126select * from c_stats where p_name =  'Rafael Nadal'
127select * from players where style_of_play = "+"'"+var+"'
128select * from players where Nationality = "+"'"+var+"'
129select * from c_stats where p_name = "+"'"+var+"'")#select * from c_stats where p_name =  request.POST.get("sqlQuery", "
130select * from c_stats where p_name =  'Rafael Nadal'
131select * from players where style_of_play = "+"'"+var+"'
132select * from players where Nationality = "+"'"+var+"'
133select * from players where p_name = "+"'"+var+"'")#select * from c_stats where p_name =  request.POST.get("sqlQuery", "
134SELECT * FROM score ORDER BY score DESC LIMIT 10;
135SELECT " + fields + " FROM " + table + ' ' + where + "ORDER BY " + id +" ASC
136SELECT id, nickname FROM players ORDER BY nickname
137SELECT COUNT(*) FROM games;
138SELECT * FROM games ORDER BY timestamp DESC LIMIT 10
139SELECT * FROM canciones ORDER BY nombre;
140SELECT nombre FROM canciones;
141SELECT id_apprenant, matricule, prenom, nom, email, date_naissance, adresse, statut, nom_promo FROM apprenant,promotion WHERE apprenant.id_promo=promotion.id_promo and apprenant.statut='inscrit'
142SELECT * FROM promotion
143""SELECT id_apprenant, matricule, prenom, nom, email, date_naissance, adresse, statut, nom_promo FROM apprenant,promotion WHERE apprenant.id_promo=promotion.id_promo and apprenant.statut='annulé' ""
144""SELECT id_apprenant, matricule, prenom, nom, email, date_naissance, adresse, statut, nom_promo FROM apprenant,promotion WHERE apprenant.id_promo=promotion.id_promo and apprenant.statut='suspendu' ""
145SELECT * FROM referentiel
146SELECT * FROM promotion
147SELECT id_apprenant, matricule, prenom, nom, email, date_naissance, adresse, statut, nom_promo FROM apprenant,promotion WHERE apprenant.id_promo=promotion.id_promo and apprenant.statut='inscrit'
148SELECT * FROM promotion
149""SELECT id_apprenant, matricule, prenom, nom, email, date_naissance, adresse, statut, nom_promo FROM apprenant,promotion WHERE apprenant.id_promo=promotion.id_promo and apprenant.statut='annulé' ""
150""SELECT id_apprenant, matricule, prenom, nom, email, date_naissance, adresse, statut, nom_promo FROM apprenant,promotion WHERE apprenant.id_promo=promotion.id_promo and apprenant.statut='suspendu' ""
151""select MAX(id_apprenant) from apprenant""
152""select * from apprenant""
153SELECT * FROM referentiel
154SELECT * FROM referentiel
155SELECT * FROM promotion
156SELECT * FROM referentiel
157SELECT id_promo, nom_promo,date_debut,date_fin, nom_ref FROM promotion,referentiel WHERE promotion.id_ref=referentiel.id_ref
158""SET work_mem TO '256MB';""
159""SET max_parallel_workers_per_gather TO 4;""
160""SET max_worker_processes TO 4;""
161""DROP AGGREGATE IF EXISTS array_accum(anyelement)""
162SELECT * FROM timezones
163SELECT * FROM geonames WHERE geonameid = '3579932'
164SELECT * FROM users ORDER BY user_id
165""CREATE FUNCTION HAMMING_DISTANCE(bytea, bytea) RETURNS integer AS 'hamming.so', 'HAMMING_DISTANCE' LANGUAGE C STRICT;""
166""CREATE SEQUENCE images_id_seq""
167""CREATE SEQUENCE pages_id_seq""
168""CREATE SEQUENCE hashes_id_seq""
169""CREATE TABLE images (id INTEGER NOT NULL DEFAULT nextval('images_id_seq') PRIMARY KEY, url TEXT, filename TEXT, created TIMESTAMP DEFAULT now(), modified TIMESTAMP DEFAULT now())""
170""CREATE TABLE pages (id INTEGER NOT NULL DEFAULT nextval('pages_id_seq') PRIMARY KEY, image_id INTEGER REFERENCES images(id), url TEXT, created TIMESTAMP DEFAULT now(), modified TIMESTAMP DEFAULT now())""
171""CREATE TABLE hashes (id INTEGER NOT NULL DEFAULT nextval('hashes_id_seq') PRIMARY KEY, image_id INTEGER REFERENCES images (id), data BYTEA, algorithm TEXT, modified TIMESTAMP DEFAULT CURRENT_TIMESTAMP)""
172DROP TABLE hashes
173DROP TABLE pages
174DROP TABLE images
175DROP SEQUENCE images_id_seq
176DROP SEQUENCE pages_id_seq
177DROP SEQUENCE hashes_id_seq
178CREATE INDEX state_index ON homeless_by_coc(state);
179CREATE INDEX state_year_index ON homeless_by_coc(state, year);
180CREATE INDEX state_count_year_index ON homeless_by_coc(state, count, year);
181CREATE INDEX measures_index ON homeless_by_coc(LOWER(measures));
182CREATE INDEX partial_state_index ON homeless_by_coc(state) WHERE count = 0;
183select lock from filterlock
184update filterlock set lock=True where id = 1
185select cnt from filterlock
186select max(id) from  page
187update filterlock set lock=False where id=1
188TRUNCATE " + tableName + " CASCADE;
189""INSERT INTO exams ("name
190select lock from filterlock
191update filterlock set lock=True where id = 1
192select cnt from filterlock
193select max(id) from  page
194update filterlock set lock=False where id=1
195SELECT * FROM users ORDER BY user_id
196SELECT * FROM query
197CREATE TABLE query (id CHARACTER VARYING(100), search CHARACTER VARYING(100))
198CREATE TABLE result (id CHARACTER VARYING(100), query CHARACTER VARYING(100), timestamp CHARACTER VARYING(100), title CHARACTER VARYING(200), content CHARACTER VARYING(500))
199SELECT * FROM query
200SELECT * FROM result
201""SELECT table_name, sync_type FROM sync_tables""
202SELECT statecode, statename FROM statecodetoname
203select * from fbmapcompetition where mapped = 't'
204select * from fbteams
205select * from fbmapteams
206select * from fbmapteams where mapped = 'F'
207select count(*) from fbmapteams
208select * from fbmapcompetition
209DELETE FROM \"RedditTopPosts\"
210SELECT COUNT(id) FROM \"RedditTopPosts\"
211DELETE FROM \"RedditTopPosts\" where viewed = TRUE
212SELECT * FROM lei ORDER BY data_inicio DESC LIMIT 10 
213SELECT * FROM usuario
214SELECT * FROM lei
215SELECT * FROM score ORDER BY score DESC LIMIT 10;
216Select * from character where status=0
217Select * from character where status=1
218SELECT " + fields + " FROM " + table + ' ' + where + "ORDER BY " + id +" ASC
219SELECT DISTINCT dept FROM classes
220SELECT title,dept,course_no FROM classes
221SELECT lastname FROM professors
222SELECT table_name FROM information_schema.tables WHERE table_schema='public'
223SELECT Drinks FROM Viewers WHERE Name='blaskatronic'
224SELECT * FROM Viewers WHERE Name='blaskatronic'
225UPDATE Viewers SET Points = Points + 1 WHERE Name='blaskatronic'
226UPDATE Viewers SET Points = Points - 2 WHERE Name='blaskatronic'
227SELECT * FROM Clips WHERE ID=1
228CREATE TABLE Clips (ID SMALLINT PRIMARY KEY, URL VARCHAR(70), Author VARCHAR(25));
229CREATE TABLE Viewers (ID SMALLINT PRIMARY KEY, Name VARCHAR(25), Points SMALLINT, Rank VARCHAR(25), Multiplier FLOAT, Lurker BIT, TotalPoints SMALLINT, DrinkExpiry TIME, Drinks SMALLINT);
230SELECT EXISTS (SELECT 1 FROM Viewers WHERE Name='" + viewer + "');
231SELECT Points FROM Viewers WHERE name='" + viewer + "';
232SELECT Lurker FROM Viewers WHERE name='" + viewer + "';
233SELECT Lurker FROM Viewers WHERE name='" + viewer + "';
234SELECT Lurker FROM Viewers WHERE name='" + viewer + "';
235SELECT Lurker FROM Viewers WHERE name='" + viewer + "';
236SELECT (points, totalPoints) FROM Viewers WHERE name='" + viewer + "';
237SELECT Drinks FROM Viewers WHERE name='" + viewer + "';
238UPDATE Viewers SET drinks=drinks + " + str(numberOfDrinks) + " WHERE name='" + viewer.lower() + "';
239SELECT Drinks FROM Viewers WHERE name='" + viewer + "';
240SELECT * FROM Clips
241SELECT * FROM Viewers WHERE name NOT IN (" + ', '.join([repr(x) for x in forbidden]) + ") ORDER BY totalpoints DESC LIMIT 10;
242SELECT * FROM Viewers WHERE name='" + viewer.lower() + "';
243SELECT totalpoints FROM Viewers WHERE name='" + userName.lower() + "';
244SELECT rank FROM Viewers WHERE name='" + userName.lower() + "';
245SELECT multiplier FROM Viewers WHERE name='" + userName.lower() + "';
246CREATE TABLE Games (ID SERIAL PRIMARY KEY, Owner VARCHAR(25), Title VARCHAR(200), Key VARCHAR(100));
247SELECT TITLE FROM Games;
248SELECT TITLE FROM Games where Owner='Sydney';
249SELECT q_id, question FROM app_questions ORDER BY q_id
250SELECT table_name from information_schema.tables order by table_name
251SELECT table_name from information_schema.tables WHERE table_schema='public' order by table_name
252SELECT table_name FROM information_schema.tables WHERE table_schema='public'
253SELECT oid, typname FROM pg_catalog.pg_type
254create table foo (id serial primary key)
255show client_encoding
256show client_encoding
257CREATE SEQUENCE fooseq
258drop table speedy_users
259SELECT table_name FROM information_schema.tables ORDER BY table_name
260SELECT table_name FROM information_schema.tables WHERE table_schema='public' ORDER BY table_name
261SELECT table_name FROM information_schema.tables WHERE table_schema='public'
262SELECT table_name FROM information_schema.tables WHERE table_schema='public'
263SELECT oid, typname FROM pg_catalog.pg_type
264""SET work_mem TO '256MB';""
265""SET max_parallel_workers_per_gather TO 4;""
266""SET max_worker_processes TO 4;""
267""DROP AGGREGATE IF EXISTS array_accum(anyelement)""
268SELECT * FROM timezones
269SELECT * FROM geonames WHERE geonameid = '3579932'
270select * from plr_set_display(':5.0');
271delete from rdata where step = 1;
272select * from plr_set_display(':5.0');
273delete from rdata where step = 2;
274select * from plr_set_display(':5.0');
275delete from rdata where step = 4;
276select * from plr_set_display(':5.0');
277 delete from rdata where step = 5;
278 select * from plr_set_display(':5.0');
279 select * from plr_set_display(':5.0');
280 select * from plr_set_display(':5.0');
281select * from import_all();
282select * from import_changes();
283SELECT link,id FROM pictures WHERE show_in_continuous = 1 ORDER BY RANDOM() LIMIT 1
284SELECT username,ngames,cum_score FROM users ORDER BY cum_score DESC
285SELECT username,ngames,cum_score FROM users ORDER BY cum_score DESC
286SELECT * FROM challenges
287SELECT table_name FROM information_schema.tables ORDER BY table_name
288SELECT table_name FROM information_schema.tables WHERE table_schema='public' ORDER BY table_name
289SELECT table_name FROM information_schema.tables WHERE table_schema='public'
290SELECT table_name FROM information_schema.tables WHERE table_schema='public'
291SELECT oid, typname FROM pg_catalog.pg_type
292SELECT * FROM events
293SELECT * from t1 WHERE id=1;
294SELECT * from t1 WHERE id=2;
295SELECT * from t1 WHERE id=1;
296SELECT * from t1 WHERE id=2;
297SELECT * from t1 WHERE id=2;
298SELECT * from t1 WHERE id=1;
299SELECT * FROM PLACES
300SELECT * FROM public.memes ORDER BY number DESC LIMIT 6
301SELECT sub_chat_id FROM subscribers
302SELECT alert_day FROM subscribers
303SELECT today_mesg_id FROM subscribers
304SELECT tomorrow_mesg_id FROM subscribers
305SELECT cid,crawled FROM contests WHERE endtime <= now() AND crawled ORDER BY endtime DESC;
306""SELECT * FROM registrants;""
307SET search_path TO dbo,public;
308DROP TABLE IF EXISTS dbo.access_log CASCADE;
309CREATE OR REPLACE VIEW dbo.Today AS SELECT * FROM dbo.access_log WHERE time_iso8601 > date_trunc('day', LOCALTIMESTAMP);
310CREATE OR REPLACE VIEW dbo.CurrentWeek AS SELECT * FROM dbo.access_log WHERE time_iso8601 > date_trunc('week', LOCALTIMESTAMP);
311CREATE OR REPLACE VIEW dbo.CurrentMonth AS SELECT * FROM dbo.access_log WHERE time_iso8601 > date_trunc('month', LOCALTIMESTAMP);
312CREATE OR REPLACE VIEW dbo.CurrentYear AS SELECT * FROM dbo.access_log WHERE time_iso8601 > date_trunc('year', LOCALTIMESTAMP);
313CREATE OR REPLACE VIEW dbo.Yesterday AS SELECT * FROM dbo.access_log WHERE time_iso8601 BETWEEN date_trunc('day', LOCALTIMESTAMP) - interval '1 day' AND date_trunc('day', LOCALTIMESTAMP);
314CREATE OR REPLACE VIEW dbo.Last7 AS SELECT * FROM dbo.access_log WHERE time_iso8601 BETWEEN date_trunc('day', LOCALTIMESTAMP) - interval '7 day' AND date_trunc('day', LOCALTIMESTAMP);
315CREATE OR REPLACE VIEW dbo.Last30 AS SELECT * FROM dbo.access_log WHERE time_iso8601 BETWEEN date_trunc('day', LOCALTIMESTAMP) - interval '30 day' AND date_trunc('day', LOCALTIMESTAMP);
316CREATE OR REPLACE VIEW dbo.MonthCal AS SELECT * FROM dbo.access_log WHERE time_iso8601 > date_trunc('day', LOCALTIMESTAMP) - interval '184 day';
317CREATE OR REPLACE VIEW dbo.DayCal AS SELECT * FROM dbo.access_log WHERE time_iso8601 > date_trunc('day', LOCALTIMESTAMP) - interval '21 day';
318CREATE OR REPLACE VIEW dbo.LastWeek AS SELECT * FROM dbo.access_log WHERE time_iso8601 BETWEEN date_trunc('week', LOCALTIMESTAMP) - interval '1 week' AND date_trunc('week', LOCALTIMESTAMP);
319CREATE OR REPLACE VIEW dbo.LastMonth AS SELECT * FROM dbo.access_log WHERE time_iso8601 BETWEEN date_trunc('month', LOCALTIMESTAMP) - interval '1 month' AND date_trunc('month', LOCALTIMESTAMP);
320CREATE OR REPLACE VIEW dbo.LastYear AS SELECT * FROM dbo.access_log WHERE time_iso8601 BETWEEN date_trunc('year', LOCALTIMESTAMP) - interval '1 year' AND date_trunc('year', LOCALTIMESTAMP);
321CREATE TABLE dbo.access_log (id serial PRIMARY KEY, remote_addr varchar,time_iso8601 timestamp,request_time real,request_uri varchar,request_method varchar,status integer,request_length integer,body_bytes_sent integer,bytes_sent integer,http_host varchar,http_referer varchar,http_user_agent varchar);
322CREATE UNIQUE INDEX id_idx ON dbo.access_log (id);
323CREATE INDEX time_idx ON dbo.access_log (time_iso8601);
324SELECT COUNT(*) FROM dbo.access_log;
325SET search_path TO dbo,public;
326SELECT DISTINCT dept FROM classes
327SELECT title,dept,course_no FROM classes
328SELECT lastname FROM professors
329SELECT building FROM locations ORDER BY building
330""SELECT distinct name, ref from planet_osm_highways_no_links where name like '%Autobahn%' and ref is not null""
331""SELECT name, ref, osm_id from planet_osm_highways_no_links where name like '%Autobahn%' and ref is null""
332""SELECT name, ref from planet_osm_highways_no_links where name not like '%Autobahn%' and ref != 'A5'""
333""SELECT name, ref from planet_osm_highways_no_links where name is null and ref != 'A5'""
334select tag_id from occ_veiculos where active = 't';
335SELECT id FROM Website ORDER BY random() LIMIT 1
336SELECT token, name FROM ApiClient
337SELECT id, url FROM Website
338SELECT * FROM BlacklistedWebsite
339TRUNCATE TABLE alarm, associateswith, citizen, citizenadmin, contact, device, devicemap, hasa, manages, useradmin, users;
340SELECT now()
341""SELECT * from subjects""
342""SELECT * from uri_status""
343""SELECT * from uri_status where not is_complete""
344SELECT table_name from information_schema.tables order by table_name
345SELECT table_name from information_schema.tables WHERE table_schema='public' order by table_name
346SELECT table_name FROM information_schema.tables WHERE table_schema='public'
347SELECT oid, typname FROM pg_catalog.pg_type
348select count(*) from estadisticas_acceso where id_telf is not null and ingreso=true
349select count(*) from estadisticas_acceso where id_telf is not null and ingreso=false
350select id_estadi_acceso from estadisticas_acceso where id_telf is not null
351select count(*) from estadisticas_acceso where id_telf is not null
352SELECT * FROM Devices WHERE id = (select MAX(id) from devices)
353INSERT INTO  sensorData(id,measurementtime,nsamples,Data, device_id) VALUES (10,'03:03:03',4,'123424141', 1);
354show client_encoding
355show client_encoding
356SELECT * FROM log_cache
357SELECT * FROM steam_user
358SELECT * FROM ip
359SELECT * FROM user_ip
360CREATE TABLE IF NOT EXISTS tutorial ( tutorial_id serial PRIMARY KEY, name varchar (50) NOT NULL );
361""SELECT * from tutorials""
362SET CLIENT_ENCODING TO 'LATIN-1';
363CREATE TABLE IF NOT EXISTS delinquincy(payer TEXT, due_date date, penalty integer )
364SELECT * from nlogs ORDER BY transtime DESC
365SELECT * from nlogs ORDER BY transtime DESC
366""SELECT * FROM parameters""
367""SELECT * FROM parameters""
368""SELECT * FROM parameters""
369""SELECT * FROM parameters""
370""SELECT * FROM "BPI" ""
371""SELECT * from tax""
372""SELECT * FROM "BPI" ""
373""SELECT * from tax""
374""SELECT * FROM "BPI" ""
375""SELECT * from tax""
376""SELECT * FROM form ""
377""SELECT * FROM form ""
378""SELECT * FROM form ""
379""SELECT * FROM form ""
380""SELECT * FROM form ""
381""SELECT * FROM form ""
382""SELECT * from deliquincy""
383""SELECT * from tax""
384""SELECT * from deliquincy""
385""SELECT * from tax""
386""SELECT * from deliquincy""
387""SELECT * from tax""
388CREATE INDEX state_idx ON homeless_by_coc(state)
389EXPLAIN (format json) SELECT * FROM homeless_by_coc WHERE state='CA' AND year > '1991-01-1'
390CREATE INDEX state_idx ON homeless_by_coc(state)
391CREATE INDEX state_idx ON homeless_by_coc(state)
392EXPLAIN ANALYZE SELECT * FROM homeless_by_coc WHERE state='CA' AND year > '1991-01-1'
393DROP INDEX IF EXISTS state_idx
394CREATE INDEX state_year_idx ON homeless_by_coc(state, year)
395EXPLAIN ANALYZE SELECT * FROM homeless_by_coc WHERE state='CA' AND year > '1991-01-1'
396CREATE INDEX state_year_coc_number_idx ON homeless_by_coc(state,year, coc_number)
397DELETE FROM homeless_by_coc
398CREATE INDEX state_year_idx ON homeless_by_coc(state, year)
399CREATE INDEX state_year_idx ON homeless_by_coc(state, year ASC)
400SELECT DISTINCT year FROM homeless_by_coc WHERE state='CA' AND year > '1991-01-01'
401CREATE INDEX measures_idx ON homeless_by_coc(lower(measures))
402SELECT * FROM homeless_by_coc WHERE lower(measures)='unsheltered homeless people in families'
403CREATE INDEX state_count_idx ON homeless_by_coc(state) WHERE count > 0
404EXPLAIN ANALYZE SELECT * FROM homeless_by_coc WHERE state='CA' AND count > 0
405CREATE INDEX state_year_measures_idx ON homeless_by_coc(state, lower(measures)) WHERE year > '2007-01-01'
406SELECT COUNT(*) as count FROM api_keys;
407SELECT api_key, user_id, email, use_count FROM api_keys LEFT JOIN users ON user_id=users.id ORDER BY use_count DESC LIMIT 50;
408SELECT COUNT(*) as count FROM data;
409SELECT COUNT(*) as count FROM users;
410BEGIN;
411LOCK TABLE data IN ACCESS EXCLUSIVE MODE;
412show client_encoding
413show client_encoding
414SELECT namn, telnr, verified FROM producent
415SELECT producent.telnr, email, namn, adress, verified FROM producent JOIN producentadress ON producent.telnr = producentadress.telnr
416SELECT konsument.email, fnamn, enamn, telnr FROM konsument JOIN konsumenttelnr ON konsument.email = konsumenttelnr.email
417SELECT * FROM artikel ORDER BY id DESC
418SELECT ID,X,Y,MVE from MOUSE
419SELECT ID,X,Y from MOUSE
420SELECT MVE, X, Y from MOUSE WHERE ID = '1'
421SELECT MVE from MOUSE WHERE ID = '1'
422UPDATE MOUSE set MVE = %s where id = 1", ("0
423UPDATE MOUSE set MVE = %s where id = 1", ("1
424select lock from filterlock
425update filterlock set lock=True where id = 1
426select cnt from filterlock
427select max(id) from  page
428update filterlock set lock=False where id=1
429select relname from pg_class where relkind='r' and relname !~ '^(pg_|sql_)';
430SELECT * FROM pg_stat_user_tables;
431select * from pg_table_def where tablename = 'media_spends' and schemaname = 'public'
432select * from ga_test
433SELECT * FROM pg_stat_user_tables;
434drop table if exists ga_test
435drop table if exists ga_test
436SELECT COLUMN_NAME FROM information_schema.COLUMNS WHERE TABLE_NAME = 'media_spends_raw'
437SELECT * from explorer limit 10
438SELECT *  FROM explorer WHERE date > '2017-12-15' and date < '2018-02-15'
439drop table 
440select relname from pg_class where relkind='r' and relname !~ '^(pg_|sql_)';
441SELECT * FROM pg_stat_user_tables;
442select * from pg_table_def where tablename = 'media_spends' and schemaname = 'public'
443select * from ga_test
444SELECT * FROM pg_stat_user_tables;
445drop table if exists ga_test
446drop table if exists ga_test
447SELECT COLUMN_NAME FROM information_schema.COLUMNS WHERE TABLE_NAME = 'media_spends_raw'
448SELECT * from explorer limit 10000
449drop table 
450select relname from pg_class where relkind='r' and relname !~ '^(pg_|sql_)';
451SELECT * FROM pg_stat_user_tables;
452select * from pg_table_def where tablename = 'media_spends' and schemaname = 'public'
453select * from ga_test
454SELECT * FROM pg_stat_user_tables;
455drop table if exists ga_test
456drop table if exists ga_test
457SELECT COLUMN_NAME FROM information_schema.COLUMNS WHERE TABLE_NAME = 'media_spends_raw'
458drop table 
459select name from occ_apto;
460select lock from filterlock
461update filterlock set lock=True where id = 1
462select cnt from filterlock
463select max(id) from  page
464update filterlock set lock=False where id=1
465show client_encoding
466show client_encoding
467SELECT * FROM questions
468SELECT * FROM questions ORDER BY answer_count DESC LIMIT 5
469SELECT * FROM articles
470select user_id, balance from coins
471select extract(year from now()) as year
472select user_id,annual_leave_remaining,annual_leave_carry from user_annual_leave where year = " + str(lastYear) + " and carry_processed = false
473select name, description, EXTRACT(YEAR from holiday_date) as year, office_id, process_event, id from public_holidays where process_event not like '';
474update user_annual_leave set annual_leave_lieu = annual_leave_lieu + " + str(1) + ", annual_leave_remaining = annual_leave_remaining + " + str(1) + " from users,public_holidays where user_annual_leave.user_id = users.id and users.primary_office_id = " + str(officeId) + " and user_annual_leave.year = " + str(year) + " and users.join_date::timestamp < public_holidays.holiday_date::timestamp and users.leave_date::timestamp > public_holidays.holiday_date::timestamp and public_holidays.id = " + str(pubHolId) + " and countholidays(public_holidays.holiday_date,public_holidays.holiday_date,(select cast (users.week_start_day as real)),(select cast (users.week_end_day as real)),users.primary_office_id) = 0; update public_holidays set process_event = '' where id = " + str(pubHolId) + "; select users.id as userid from users,public_holidays where users.primary_office_id = " + str(officeId) + " and public_holidays.office_id = users.primary_office_id and users.join_date::timestamp < public_holidays.holiday_date::timestamp and users.leave_date::timestamp > public_holidays.holiday_date::timestamp and public_holidays.id = " + str(pubHolId) + " and countholidays(public_holidays.holiday_date,public_holidays.holiday_date,( select cast (users.week_start_day as real)),(select cast (users.week_end_day as real)),users.primary_office_id) = 0;
475update user_annual_leave set annual_leave_lieu = annual_leave_lieu - " + str(1) + ", annual_leave_remaining = annual_leave_remaining - " + str(1) + " from users,public_holidays where user_annual_leave.user_id = users.id and users.primary_office_id = " + str(officeId) + " and user_annual_leave.year = " + str(year) + " and users.join_date::timestamp < public_holidays.holiday_date::timestamp and users.leave_date::timestamp > public_holidays.holiday_date::timestamp and public_holidays.id = " + str(pubHolId) + " and countholidays(public_holidays.holiday_date,public_holidays.holiday_date,(select cast (users.week_start_day as real)),(select cast (users.week_end_day)),users.primary_office_id) = 0; select users.id as userid from users,public_holidays where users.primary_office_id = " + str(officeId) + " and public_holidays.office_id = users.primary_office_id and users.join_date::timestamp < public_holidays.holiday_date::timestamp and users.leave_date::timestamp > public_holidays.holiday_date::timestamp and public_holidays.id = " + str(pubHolId) + " and countholidays(public_holidays.holiday_date,public_holidays.holiday_date,(select cast(users.week_start_day as real)),(select cast (users.week_end_day as real)),users.primary_office_id) = 0;
476delete from public_holidays where id = " + str(pubHolId) + ";
477select username, week_start_day, week_end_day, join_date, leave_date, primary_office_id, process_event, id from users where process_event not like '';
478insert into lieu_days values ('" + pubHolName + "'," + str(1) + "," + str(userId) + "," + str(1) + ",'" + str(pubHolYear) + "'," + str(pubHolId) + "); update user_annual_leave set annual_leave_lieu = annual_leave_lieu + " + str(1) + ", annual_leave_remaining = annual_leave_remaining + " + str(1) + " from users where user_annual_leave.user_id = users.id and user_annual_leave.year = " + str(pubHolYear) + " and users.id = " + str(userId) + ";
479delete from lieu_days where public_holiday_id = " + str(pubHolId) + " and given_to_user_id = " + str(userId) + " and year = " + str(pubHolYear) + "; update user_annual_leave set annual_leave_lieu = annual_leave_lieu - " + str(1) + ", annual_leave_remaining = annual_leave_remaining - " + str(1) + " from users where user_annual_leave.user_id = users.id and user_annual_leave.year = " + str(pubHolYear) + " and users.id = " + str(userId) + ";
480update users set process_event = '' where id = " + str(userId) + ";
481SELECT column_name FROM information_schema.columns WHERE table_schema = 'public' AND table_name='"+table+"'
482SELECT data_type FROM information_schema.columns WHERE table_schema = 'public' AND table_name='"+table+"'
483UPDATE "+table+" SET "+set+" WHERE "+field+"="+data['where'][field]+"
484SELECT * FROM test WHERE name LIKE 't%'
485SELECT payload FROM texts WHERE document_type IN ('ETHOS', 'AI', 'MATH') ORDER BY RANDOM() LIMIT 1
486SELECT COUNT(*) FROM texts WHERE document_type = 'ETHOS'
487SELECT payload FROM texts WHERE document_type = 'KOAN' ORDER BY RANDOM() LIMIT 1
488UPDATE intelligence SET tags = '{\"intelligence\"}' WHERE NOT ('science' = ANY (tags))
489UPDATE intelligence SET tags = '{\"science\"}' WHERE 'science' = ANY (tags)
490UPDATE intelligence SET origin = 'intelligence' WHERE origin != 'science'
491SELECT bot_predicates FROM nlu.bot_predicates LIMIT 1
492SELECT model FROM nlu.trained_models LIMIT 1
493SELECT lat_long FROM weather_location_default
494DELETE FROM weather_location_default
495SELECT user_name FROM users
496SELECT * FROM genero;
497SELECT * FROM video
498SELECT * FROM curtir
499SELECT * FROM comentar
500SELECT * FROM curtir
501SELECT * FROM comentar
502SELECT * FROM genero;
503SELECT * FROM genero;
504create  TABLE address_principals_lot AS (select * from \"public\".address_principals)
505ALTER TABLE address_principals_lot ADD COLUMN plot varchar(50);
506ALTER TABLE address_principals_lot ADD COLUMN plan varchar(50);
507SELECT gid,legal_parcel_id from address_principals_lot where state ='SA'
508SELECT gid,legal_parcel_id from address_principals_plot where state ='NSW'
509SELECT gid,legal_parcel_id from address_principals_plot where state ='QLD'
510SELECT gid,legal_parcel_id from address_principals_plot where state ='VIC'
511SELECT gid,legal_parcel_id from address_principals_plot where state ='WA'
512SELECT ogc_fid,survey_plan_number from nt_dcdb
513SELECT gid,legal_parcel_id from address_principals_plot where state ='TAS'
514SELECT column_name FROM information_schema.columns WHERE table_schema = 'public' AND table_name='"+table+"'
515INSERT INTO "+table+" "+column+" VALUES "+value+" RETURNING *
516UPDATE "+table+" SET "+set+" WHERE "+field+"="+data['where'][field]+"
517show client_encoding
518show client_encoding
519select * from warnings where device_id = '005' order by warning_time
520select count(device_id), acceleration_time from peak_accel where acceleration_time > '2020-01-05 04:48:00' group by acceleration_time order by acceleration_time LIMIT 500
521select * from peak_accel where acceleration_time = '2020-01-05 04:43:00' order by device_id LIMIT 400
522select * from warnings where device_id = '001' order by warning_time
523show client_encoding
524show client_encoding
525SELECT * FROM messages WHERE room = 'public';
526SELECT * FROM rooms;
527SELECT first_name, last_name FROM guests WHERE rsvp = 'Y';
528SELECT first_name, last_name FROM guests WHERE rsvp = 'N';
529SELECT first_name, last_name FROM guests WHERE rsvp = 'F';
530SELECT SUM(number_of_extras) AS num FROM guests where rsvp = 'Y';
531SELECT * FROM gifts WHERE recieved = 'F';
532SELECT * FROM gifts WHERE recieved = 'F';
533SELECT * FROM gifts WHERE recieved = 'F';
534SELECT * FROM gifts WHERE recieved = 'F';
535SELECT thankyous.gift, guests.first_name AS first, guests.last_name AS last, guests.address FROM thankyous JOIN guests ON (thankyous.username = guests.username);
536SELECT first_name, last_name FROM guests WHERE rsvp = 'Y';
537Select * FROM hackathon
538SELECT address FROM hackathon WHERE address LIKE (%s)", ("
539""SELECT address FROM hackathon WHERE address LIKE '255 RED ROCK WY%'""
540SELECT * FROM test WHERE name LIKE 't%'
541SELECT department_id, department_name FROM department;
542SELECT department_id, department_city FROM department;
543ALTER TABLE employee DROP COLUMN temp_table
544CREATE DATABASE tcount
545select max (counts) from clock;
546select max (counts) from clock;
547select max (counts) from clock;
548select max (counts) from clock;
549select max (counts) from clock;
550select max (counts) from clock;
551select count(*) from acl;
552select count(*) from tacl;
553SELECT mealtype.meal, availability.starttime, availability.endtime, users.username, availability.id FROM availability JOIN mealtype ON availability.mealtype = mealtype.id JOIN users ON availability.userid = users.id ORDER BY users.username
554CREATE DATABASE tcount
555SELECT group_name FROM timetable;
556SELECT today, tomorrow FROM timetable WHERE group_name = %s AND last_update = %s LIMIT 1", (name, dt.strftime("%Y.%m.%d
557CREATE TABLE timetable (group_name varchar PRIMARY KEY, last_update date, today text[][], tomorrow text[][]) ENCODING='UTF8';
558SELECT * FROM timetable;
559select column_name from information_schema.columns where table_name='stud'
560select column_name from information_schema.columns where table_name='"+table_name+"'
561UPDATE "+table_name+" SET flag=1
562select * from "+table_name+" where flag = 1
563SELECT * FROM account_holder
564SELECT * FROM party_global_data
565ALTER TABLE time_drinks ADD COLUMN " + st + " INTEGER
566""select id, ST_AsGeoJSON(geom) from depos where is_depo""
567""select id, ST_AsGeoJSON(geom) from depos where not is_depo""
568""select osm_id,name from planet_osm_polygon where admin_level = '4'""
569SELECT id FROM band
570SELECT id FROM album
571SELECT id FROM song
572SELECT * FROM users
573DROP TABLE users
574CREATE TABLE users (uid text PRIMARY KEY, handle text, rating text)
575SELECT * FROM users
576SELECT * FROM users
577SELECT COUNT(*) FROM pg_database WHERE datallowconn='t';
578SELECT datname FROM pg_database WHERE datallowconn='t';
579DROP SCHEMA IF EXISTS pglogical CASCADE
580CREATE TEMP TABLE " + temp_table + " (content text)
581SELECT * FROM " + temp_table + ";
582DROP OWNED BY " + username + " CASCADE
583""DELETE FROM images_cvresults""
584""DELETE FROM images""
585""DELETE FROM cvresults""
586""SELECT id FROM cvresults ORDER BY id DESC LIMIT 1""
587SELECT nextval('posts_id_seq')
588SELECT COUNT(*) FROM posts
589DELETE FROM posts
590""SET work_mem TO '256MB';""
591""SET max_parallel_workers_per_gather TO 4;""
592""SET max_worker_processes TO 4;""
593""DROP AGGREGATE IF EXISTS array_accum(anyelement)""
594SELECT * FROM timezones
595SELECT * FROM geonames WHERE geonameid = '3579932'
596INSERT INTO uczestnik (login, haslo, organizator) VALUES (%s, %s, %s)", (newlogin, newpassword, "true
597SELECT id, poczatek, temat, sala FROM obecnosc JOIN referat ON (referatid=id) GROUP BY id, poczatek, temat, sala ORDER BY COUNT(uczestnikid)
598SELECT id, poczatek, temat, sala FROM referat WHERE sala IS NULL or wydarzenieid IS NULL;
599SELECT * FROM wydarzenie;
600SELECT index FROM blck
601SELECT datname FROM pg_catalog.pg_database WHERE datname = 'blck'
602SELECT datname FROM pg_catalog.pg_database WHERE datname = 'transaction'
603SELECT datname FROM pg_catalog.pg_database WHERE datname = 'transaction'
604SELECT datname FROM pg_catalog.pg_database WHERE datname = 'payload'
605SELECT datname FROM pg_catalog.pg_database WHERE datname = 'payload'
606SELECT COUNT(*) FROM threads
607DELETE FROM threads
608SELECT * from movies ORDER BY RANDOM() DESC LIMIT 30
609select count(*) from auth_user
610SELECT * from movies ORDER BY imdbrating DESC LIMIT 100
611SELECT * from movies where imdbrating > 0 ORDER BY imdbrating ASC LIMIT 100
612BEGIN;
613SELECT index FROM blck
614SELECT datname FROM pg_catalog.pg_database WHERE datname = 'blck'
615SELECT datname FROM pg_catalog.pg_database WHERE datname = 'transaction'
616SELECT datname FROM pg_catalog.pg_database WHERE datname = 'transaction'
617SELECT datname FROM pg_catalog.pg_database WHERE datname = 'payload'
618SELECT datname FROM pg_catalog.pg_database WHERE datname = 'payload'
619SELECT * FROM usuario WHERE email='"+email+"'
620SELECT * FROM usuario WHERE nome LIKE '"+ "%" + nome + "%'
621SELECT * FROM amigos WHERE nome like '"+ "%" + str(nome)+ "%" + "'
622update usuario set profissao = '"+str(nova_profissao)+ "'" + " where email = '"+str(email)+"'
623delete from amigos where email_user = '"+str(email)+"' and email_amigo = "+"'"+str(email_amigo)+"'
624delete from amigos where email_user = '"+str(email_amigo)+"' and email_amigo = "+"'"+str(email)+"'
625update login set senha = '"+str(nova_senha)+ "'" + " where email = '"+str(email)+"'
626DELETE FROM login WHERE email='"+ str(email)+ "'
627DELETE FROM amigos WHERE email_user='"+ str(email)+ "' or email_amigo='"+ str(email)+ "'
628DELETE FROM publicacao WHERE email_user='"+ str(email)+ "'
629DELETE FROM usuario WHERE email='"+ str(email)+ "'
630SELECT * FROM oseba
631SELECT table_name FROM information_schema.tables WHERE table_schema='public' ORDER BY table_name
632SELECT table_name FROM information_schema.tables WHERE table_schema='public'
633SELECT table_name FROM information_schema.tables ORDER BY table_name;
634SELECT table_name FROM information_schema.tables WHERE table_schema = 'public' ORDER BY table_name;
635SELECT table_name FROM information_schema.tables WHERE table_schema='public'
636SELECT oid,typname FROM pg_catalog.pg_type
637SELECT roomname FROM rooms;
638SELECT roomname FROM rooms;
639SELECT * FROM student;
640SELECT * FROM courses;
641INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) VALUES (1, 'Paul', 32, 'California', 20000.00 )
642INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) VALUES (2, 'Allen', 25, 'Texas', 15000.00 )
643INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) VALUES (3, 'Teddy', 23, 'Norway', 20000.00 )
644INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) VALUES (4, 'Mark', 25, 'Rich-Mond ', 65000.00 )
645SELECT column_name FROM information_schema.columns WHERE table_schema = 'public' AND table_name='"+table+"'
646INSERT INTO "+table+" "+column+" VALUES "+value+" RETURNING *
647UPDATE "+table+" SET "+set+" WHERE "+field+"="+data['where'][field]+"
648""SELECT * FROM Customers WHERE blacklist='true';""
649""SELECT * FROM customers ORDER BY cu_id DESC limit 50;""
650select * from category_table
651select * from emotick
652show client_encoding
653show client_encoding
654DELETE FROM admin_path_faculty
655""SELECT nb_leaves  from Admin_leave ORDER BY id DESC""
656create temporary table mystories (like stories);
657alter table mystories add column ord bigserial;
658alter table mystories add column  cachedreplycount bigint;
659drop table mystories
660create temporary table mystories (like stories);
661alter table mystories add column ord bigserial;
662alter table mystories add column  cachedreplycount bigint;
663drop table mystories
664select * from chanclasses;
665select count(subbedchan) as count,chanid,name,chanclass from usrsubs right join channels on subbedchan = chanid group by chanid,name order by count desc;
666select subbedchan from usrsubs where usr = 0
667show client_encoding
668show client_encoding
669SELECT POST_ID, DATA, COUNT, COMMENTS from POSTS ORDER BY COUNT DESC
670DROP TABLE IF EXISTS Utenti CASCADE
671DROP TABLE IF EXISTS Commemti CASCADE
672CREATE TABLE Utenti (ID VARCHAR(50) PRIMARY KEY references Commenti(Da), Nome VARCHAR(50), Nazionalita VARCHAR(20), Citta VARCHAR(30))
673CREATE TABLE Recensioni (Da VARCHAR(50) references Utenti(ID),A VARCHAR(50) references Utenti(ID), Voto smallint, data VARCHAR(10), Testo text)
674CREATE TABLE IF NOT EXISTS nazionalita (nazionalita_id  serial, nazionalita varchar(80) unique not null, primary key(nazionalita_id));
675select count(*) from pg_class where relname='nazionalita' and relkind='r'
676CREATE INDEX nazionalitaIDX1 ON nazionalita(nazionalita);
677CREATE TABLE IF NOT EXISTS citta (citta_id serial, citta varchar(80) not null, nazionalita_id  int not null, primary key(citta_id), foreign key(nazionalita_id) references nazionalita(nazionalita_id));
678select count(*) from pg_class where relname='citta' and relkind='r'
679CREATE INDEX IF NOT EXISTS cittaIDX1 ON citta(citta);
680CREATE TABLE IF NOT EXISTS utente (utente_id serial, cs_id varchar(100) unique not null, visitato bool default false, nome varchar(80), eta int2, citta_id int, registrazione date, primary key(utente_id), foreign key(citta_id) references citta(citta_id));
681select count(*) from pg_class where relname='utente' and relkind='r'
682CREATE INDEX utenteIDX1 ON utente(cs_id);
683CREATE TABLE IF NOT EXISTS commento (commento_id  serial, autore int not null, ospite int not null, data date not null, commento text, voto int2, primary key(commento_id), unique(autore,ospite,data), foreign key(autore) references utente(utente_id), foreign key(ospite) references utente(utente_id), CHECK(voto BETWEEN -1 AND 1) );
684select count(*) from pg_class where relname='commento' and relkind='r'
685CREATE INDEX commentoIDX1 ON commento(autore); CREATE INDEX commentoIDX2 ON commento(ospite);
686SELECT Count(*) FROM utente WHERE ID='"+userid+"'
687SELECT utente_id FROM utente WHERE cs_id='"+da+"'
688SELECT utente_id FROM utente WHERE cs_id='"+a+"'
689SELECT utente_id FROM utente WHERE cs_id='"+da+"'
690SELECT utente_id FROM utente WHERE cs_id='"+a+"'
691SELECT cs_id FROM utente where visitato=FALSE
692COMMIT
693COMMIT
694DELETE FROM posts where channelid in (SELECT id FROM channels where deleteat <> 0)
695DELETE FROM channelmembers WHERE channelid in (SELECT id FROM channels WHERE deleteat <> 0)
696DELETE FROM channels WHERE deleteat <> 0
697DELETE FROM posts where deleteat <> 0
698DELETE FROM commands where deleteat <> 0
699SET TIME ZONE 'America/Fortaleza';
700SET TIME ZONE 'America/Fortaleza';
701SET TIME ZONE 'America/Fortaleza';
702SET TIME ZONE 'America/Fortaleza';
703SET TIME ZONE 'America/Fortaleza';
704SET TIME ZONE 'America/Fortaleza';
705SET TIME ZONE 'America/Fortaleza';
706SET TIME ZONE 'America/Fortaleza';
707SET TIME ZONE 'America/Fortaleza';
708SET TIME ZONE 'America/Fortaleza';
709SET TIME ZONE 'America/Fortaleza';
710SET TIME ZONE 'America/Fortaleza';
711""SELECT * FROM Usuario""
712""SELECT * FROM Veiculo WHERE status != 'Removido'""
713""SELECT * FROM motorista WHERE status is null""
714""SELECT * FROM viagem WHERE status is null""
715""SELECT * FROM motorista WHERE status is null""
716""SELECT * FROM veiculo""
717""SELECT * FROM Revisao WHERE status is null""
718""SELECT * FROM veiculo""
719SELECT * FROM purchases
720CREATE INDEX state_idx ON homeless_by_coc(state)
721EXPLAIN (format json) SELECT * FROM homeless_by_coc WHERE state='CA' AND year > '1991-01-1'
722CREATE INDEX state_idx ON homeless_by_coc(state)
723CREATE INDEX state_idx ON homeless_by_coc(state)
724EXPLAIN ANALYZE SELECT * FROM homeless_by_coc WHERE state='CA' AND year > '1991-01-1'
725DROP INDEX IF EXISTS state_idx
726CREATE INDEX state_year_idx ON homeless_by_coc(state, year)
727EXPLAIN ANALYZE SELECT * FROM homeless_by_coc WHERE state='CA' AND year > '1991-01-1'
728CREATE INDEX state_year_coc_number_idx ON homeless_by_coc(state,year, coc_number)
729DELETE FROM homeless_by_coc
730CREATE INDEX state_year_idx ON homeless_by_coc(state, year)
731CREATE INDEX state_year_idx ON homeless_by_coc(state, year ASC)
732SELECT DISTINCT year FROM homeless_by_coc WHERE state='CA' AND year > '1991-01-01'
733CREATE INDEX measures_idx ON homeless_by_coc(lower(measures))
734SELECT * FROM homeless_by_coc WHERE lower(measures)='unsheltered homeless people in families'
735CREATE INDEX state_count_idx ON homeless_by_coc(state) WHERE count > 0
736EXPLAIN ANALYZE SELECT * FROM homeless_by_coc WHERE state='CA' AND count > 0
737CREATE INDEX state_year_measures_idx ON homeless_by_coc(state, lower(measures)) WHERE year > '2007-01-01'
738""INSERT INTO "{}" ({}) VALUES ({});""".format(table_name, str(self.db_indexcol(table_name)[1:]).replace("'", "").replace("[", "").replace("]", ""), "%s," * (len(self.db_indexcol(table_name)) - 2) + "%s
739SELECT nextval('posts_id_seq')
740SELECT COUNT(*) FROM posts
741DELETE FROM posts
742SELECT note('hi there')
743SELECT note('another note')
744show client_encoding
745show client_encoding
746CREATE SEQUENCE fooseq
747drop table speedy_users
748UPDATE storeHistory SET isLastRun = 'f' WHERE isLastRun = 't'
749INSERT INTO storeHistory(id, name, price, url) SELECT id, name, price, url FROM currentStore
750DELETE FROM currentStore
751DELETE FROM StoreHistory WHERE isLastRun = 'f' AND historydate < current_timestamp - interval '8 hour'
752UPDATE SpacePigeon_Parameter SET Notification_Done = false
753SELECT serverid, Notification_Role_Id, Notification_Channel_Id FROM SpacePigeon_Parameter
754SELECT ServerId, Notification_Role_Id, Notification_Channel_Id FROM SpacePigeon_Parameter WHERE Notification_Done = false
755UPDATE SpacePigeon_Parameter SET Notification_Done = 't' WHERE ServerId = '" + serverId + "'
756SELECT id, name, price, deltaPrice, deltaPricePercent, url, imageurl FROM StoreDiff
757SELECT * FROM books
758show client_encoding
759show client_encoding
760SELECT * FROM english_words
761UPDATE wordlist SET path_audio = '" + path_audio + '.mp3' + "' WHERE en_word = '" + path_audio + "' RETURNING path_audio;
762CREATE TABLE aux (id serial PRIMARY KEY, cod_pontoA integer, cod_pontoB integer, distanciaBruto float, distanciaTratado float , dataA BYTEA , dataB BYTEA, FOREIGN KEY (cod_pontoA) REFERENCES ponto, FOREIGN KEY (cod_pontoB) REFERENCES ponto)
763drop table aux
764SELECT DISTINCT gl_id FROM gl_sn;
765SELECT DISTINCT * FROM gl_sn;
766SELECT %s AS foo", (decimal.Decimal("19.10
767SELECT %s AS foo", (decimal.Decimal("NaN
768SELECT %s AS foo", (decimal.Decimal("infinity
769SELECT %s AS foo", (decimal.Decimal("-infinity
770SELECT %s AS foo", (float("nan
771select 'inf'::float
772SELECT %s AS foo", (float("inf
773SELECT %s AS foo", (float("-inf
774select col from array_test where id = 1
775select col from array_test where id = 2
776SELECT '{}' AS foo
777SELECT '{}'::text[] AS foo
778SELECT '{}'::text AS foo
779select '{1, 2, 3}'::int4[]
780select array['a', 'b', '''']::text[]
781select '{1, 2, 3}'::int4[]
782select '{1, 2, NULL}'::int4[]
783select '{192.168.0.1/24}'::inet[]
784select '{192.168.0.0/24}'::cidr[]
785select '{10:20:30:40:50:60}'::macaddr[]
786CREATE EXTENSION postgis
787CREATE SCHEMA IF NOT EXISTS gps_data
788CREATE SCHEMA IF NOT EXISTS raster_data
789SELECT %s AS foo", (decimal.Decimal("19.10
790SELECT %s AS foo", (decimal.Decimal("NaN
791SELECT %s AS foo", (decimal.Decimal("infinity
792SELECT %s AS foo", (decimal.Decimal("-infinity
793SELECT %s AS foo", (float("nan
794select 'inf'::float
795SELECT %s AS foo", (float("inf
796SELECT %s AS foo", (float("-inf
797select col from array_test where id = 1
798select col from array_test where id = 2
799SELECT '{}' AS foo
800SELECT '{}'::text[] AS foo
801SELECT '{}'::text AS foo
802select '{1, 2, 3}'::int4[]
803select array['a', 'b', '''']::text[]
804select '{1, 2, 3}'::int4[]
805select '{1, 2, NULL}'::int4[]
806select '{192.168.0.1/24}'::inet[]
807select '{192.168.0.0/24}'::cidr[]
808select '{10:20:30:40:50:60}'::macaddr[]
809SELECT 'hstore'::regtype::oid
810SHOW ALL
811SELECT table_name FROM information_schema.tables ORDER BY table_name
812SELECT table_name FROM information_schema.tables WHERE table_schema='public' ORDER BY table_name
813SELECT table_name FROM information_schema.tables WHERE table_schema='public'
814SELECT table_name FROM information_schema.tables WHERE table_schema='public'
815SELECT oid, typname FROM pg_catalog.pg_type
816SELECT user_id, user_name, user_telegram FROM users WHERE user_telegram IS NOT NULL
817SELECT user_id, user_name, user_nickname FROM users ORDER BY user_name
818SELECT user_id, user_name, user_nickname FROM users ORDER BY user_name
819SELECT user_id, user_name, user_nickname FROM users ORDER BY user_name
820SELECT user_id, user_name, user_nickname FROM users WHERE user_alive = 'f' ORDER BY user_name
821SELECT user_id, user_name, user_nickname, user_alive FROM users ORDER BY user_alive DESC, user_name
822SELECT MAX(user_id) FROM users
823SELECT %s AS foo", (decimal.Decimal("19.10
824SELECT %s AS foo", (decimal.Decimal("NaN
825SELECT %s AS foo", (decimal.Decimal("infinity
826SELECT %s AS foo", (decimal.Decimal("-infinity
827SELECT %s AS foo", (float("nan
828select 'inf'::float
829SELECT %s AS foo", (float("inf
830SELECT %s AS foo", (float("-inf
831select col from array_test where id = 1
832select col from array_test where id = 2
833SELECT '{}' AS foo
834SELECT '{}'::text[] AS foo
835SELECT '{}'::text AS foo
836select '{1, 2, 3}'::int4[]
837select array['a', 'b', '''']::text[]
838select '{1, 2, 3}'::int4[]
839select '{1, 2, NULL}'::int4[]
840select '{192.168.0.1/24}'::inet[]
841select '{192.168.0.0/24}'::cidr[]
842select '{10:20:30:40:50:60}'::macaddr[]
843Select distinct exercise_name from musclegroup
844SELECT table_name FROM information_schema.tables ORDER BY table_name
845SELECT table_name FROM information_schema.tables WHERE table_schema='public' ORDER BY table_name
846SELECT table_name FROM information_schema.tables WHERE table_schema='public'
847SELECT table_name FROM information_schema.tables WHERE table_schema='public'
848SELECT oid, typname FROM pg_catalog.pg_type
849show client_encoding
850show client_encoding
851show client_encoding
852show client_encoding
853SELECT %s AS foo", (decimal.Decimal("19.10
854SELECT %s AS foo", (decimal.Decimal("NaN
855SELECT %s AS foo", (decimal.Decimal("infinity
856SELECT %s AS foo", (decimal.Decimal("-infinity
857SELECT %s AS foo", (float("nan
858select 'inf'::float
859SELECT %s AS foo", (float("inf
860SELECT %s AS foo", (float("-inf
861select col from array_test where id = 1
862select col from array_test where id = 2
863SELECT '{}' AS foo
864SELECT '{}'::text[] AS foo
865SELECT '{}'::text AS foo
866select '{1, 2, 3}'::int4[]
867select array['a', 'b', '''']::text[]
868select '{1, 2, 3}'::int4[]
869select '{1, 2, NULL}'::int4[]
870select '{192.168.0.1/24}'::inet[]
871select '{192.168.0.0/24}'::cidr[]
872select '{10:20:30:40:50:60}'::macaddr[]
873SELECT %s AS foo", (decimal.Decimal("19.10
874SELECT %s AS foo", (decimal.Decimal("NaN
875SELECT %s AS foo", (decimal.Decimal("infinity
876SELECT %s AS foo", (decimal.Decimal("-infinity
877SELECT %s AS foo", (float("nan
878select 'inf'::float
879SELECT %s AS foo", (float("inf
880SELECT %s AS foo", (float("-inf
881select col from array_test where id = 1
882select col from array_test where id = 2
883SELECT '{}' AS foo
884SELECT '{}'::text[] AS foo
885SELECT '{}'::text AS foo
886select '{1, 2, 3}'::int4[]
887select array['a', 'b', '''']::text[]
888select '{1, 2, 3}'::int4[]
889select '{1, 2, NULL}'::int4[]
890select '{192.168.0.1/24}'::inet[]
891select '{192.168.0.0/24}'::cidr[]
892select '{10:20:30:40:50:60}'::macaddr[]
893select * from \"ProcessTracking\"
894show client_encoding
895show client_encoding
896Select distinct exercise_name from musclegroup
897SELECT %s AS foo", (decimal.Decimal("19.10
898SELECT %s AS foo", (decimal.Decimal("NaN
899SELECT %s AS foo", (decimal.Decimal("infinity
900SELECT %s AS foo", (decimal.Decimal("-infinity
901SELECT %s AS foo", (float("nan
902select 'inf'::float
903SELECT %s AS foo", (float("inf
904SELECT %s AS foo", (float("-inf
905select col from array_test where id = 1
906select col from array_test where id = 2
907SELECT '{}' AS foo
908SELECT '{}'::text[] AS foo
909SELECT '{}'::text AS foo
910select '{1, 2, 3}'::int4[]
911select array['a', 'b', '''']::text[]
912select '{1, 2, 3}'::int4[]
913select '{1, 2, NULL}'::int4[]
914select '{192.168.0.1/24}'::inet[]
915select '{192.168.0.0/24}'::cidr[]
916select '{10:20:30:40:50:60}'::macaddr[]
917SELECT COUNT(*) FROM threads
918DELETE FROM threads
919select datid,datname,numbackends from pg_stat_database where datname='mydb';
920SELECT pg_conf_load_time();
921SELECT current_query();
922SELECT query FROM pg_stat_activity;
923rollback
924rollback
925rollback
926rollback
927rollback
928rollback
929rollback
930rollback
931select count(*) from planet_osm_line;
932select osm_id, ST_length(way) from planet_osm_line order by ST_length(way) desc limit 10;;
933update planet_osm_line set way=ST_OffsetCurve(way,"+str(20*of)+
934delete from planet_osm_line where st_isempty(way);
935insert into comments (todo_id, name) values ('" + todoid + "', " + name + ");
936select * from comments where todo_id = " + todoid + ";
937show client_encoding
938show client_encoding
939select id,name,password,singal from public.member where id>0
940update public.member set name='update ...' where id=2
941select id,name,password,singal from public.member
942select id,name,password,singal from public.member
943delete from public.member where id=4
944select id,name,password,singal from public.member
945SELECT %s AS foo", (decimal.Decimal("19.10
946SELECT %s AS foo", (decimal.Decimal("NaN
947SELECT %s AS foo", (decimal.Decimal("infinity
948SELECT %s AS foo", (decimal.Decimal("-infinity
949SELECT %s AS foo", (float("nan
950select 'inf'::float
951SELECT %s AS foo", (float("inf
952SELECT %s AS foo", (float("-inf
953select col from array_test where id = 1
954select col from array_test where id = 2
955SELECT '{}' AS foo
956SELECT '{}'::text[] AS foo
957SELECT '{}'::text AS foo
958select '{1, 2, 3}'::int4[]
959select array['a', 'b', '''']::text[]
960select '{1, 2, 3}'::int4[]
961select '{1, 2, NULL}'::int4[]
962select '{192.168.0.1/24}'::inet[]
963select '{192.168.0.0/24}'::cidr[]
964select '{10:20:30:40:50:60}'::macaddr[]
965insert into comments (todo_id, name) values ('" + todoid + "', " + name + ");
966select * from comments where todo_id = " + todoid + ";
967SELECT id, raw_name FROM staff
968""SELECT DISTINCT school FROM module WHERE module_coordinator='%s'""" % staff_name.replace("'","''
969show client_encoding
970show client_encoding
971SELECT *  from burger
972SELECT *  from shake
973SELECT *  from salad
974SELECT *  from pasta
975SELECT *  from beverage
976UPDATE albums SET users_json = '[]';
977SET bytea_output TO 'escape'
978SELECT %s AS foo", (decimal.Decimal("19.10
979SELECT %s AS foo", (decimal.Decimal("NaN
980SELECT %s AS foo", (decimal.Decimal("infinity
981SELECT %s AS foo", (decimal.Decimal("-infinity
982SELECT %s AS foo", (float("nan
983select 'inf'::float
984SELECT %s AS foo", (float("inf
985SELECT %s AS foo", (float("-inf
986select col from array_test where id = 1
987select col from array_test where id = 2
988SELECT '{}' AS foo
989SELECT '{}'::text[] AS foo
990SELECT '{}'::text AS foo
991select '{1, 2, 3}'::int4[]
992select array['a', 'b', '''']::text[]
993select '{1, 2, 3}'::int4[]
994select '{1, 2, NULL}'::int4[]
995select '{192.168.0.1/24}'::inet[]
996select '{192.168.0.0/24}'::cidr[]
997select '{10:20:30:40:50:60}'::macaddr[]
998select account_id, email from users where last_sign_in_at < now() - interval '365 days' and disabled=False and approved=True order by last_sign_in_at desc;
999SELECT %s AS foo", (decimal.Decimal("19.10
1000SELECT %s AS foo", (decimal.Decimal("NaN
1001SELECT %s AS foo", (decimal.Decimal("infinity
1002SELECT %s AS foo", (decimal.Decimal("-infinity
1003SELECT %s AS foo", (float("nan
1004select 'inf'::float
1005SELECT %s AS foo", (float("inf
1006SELECT %s AS foo", (float("-inf
1007select col from array_test where id = 1
1008select col from array_test where id = 2
1009SELECT '{}' AS foo
1010SELECT '{}'::text[] AS foo
1011SELECT '{}'::text AS foo
1012select '{1, 2, 3}'::int4[]
1013select array['a', 'b', '''']::text[]
1014select '{1, 2, 3}'::int4[]
1015select '{1, 2, NULL}'::int4[]
1016select '{192.168.0.1/24}'::inet[]
1017select '{192.168.0.0/24}'::cidr[]
1018select '{10:20:30:40:50:60}'::macaddr[]
1019SELECT %s AS foo", (decimal.Decimal("19.10
1020SELECT %s AS foo", (decimal.Decimal("NaN
1021SELECT %s AS foo", (decimal.Decimal("infinity
1022SELECT %s AS foo", (decimal.Decimal("-infinity
1023SELECT %s AS foo", (float("nan
1024select 'inf'::float
1025SELECT %s AS foo", (float("inf
1026SELECT %s AS foo", (float("-inf
1027select col from array_test where id = 1
1028select col from array_test where id = 2
1029SELECT '{}' AS foo
1030SELECT '{}'::text[] AS foo
1031SELECT '{}'::text AS foo
1032select '{1, 2, 3}'::int4[]
1033select array['a', 'b', '''']::text[]
1034select '{1, 2, 3}'::int4[]
1035select '{1, 2, NULL}'::int4[]
1036select '{192.168.0.1/24}'::inet[]
1037select '{192.168.0.0/24}'::cidr[]
1038select '{10:20:30:40:50:60}'::macaddr[]
1039show client_encoding
1040show client_encoding
1041show client_encoding
1042show client_encoding
1043SELECT * FROM hero
1044SELECT * FROM karte
1045Select * from karte Join hero on hero.id = karte.class ;
1046SELECT * FROM deck
1047Select * from hero
1048Select * from hero
1049Select * from hero
1050Select * from hero
1051select title from books
1052select * from books1
1053SELECT users.name as name, count(posts.post_id) as posts FROM users, posts WHERE posts.user_id = users.user_id GROUP BY users.name HAVING count(posts.post_id) >= 10
1054SELECT subreddits.sub_name as subs FROM posts, subreddits WHERE posts.subreddit_id = subreddits.sub_id GROUP BY subreddits.sub_name
1055SELECT column_name FROM information_schema.columns WHERE table_schema = 'public' AND table_name='"+table+"'
1056SELECT data_type FROM information_schema.columns WHERE table_schema = 'public' AND table_name='"+table+"'
1057INSERT INTO "+table+" "+column+" VALUES "+value+" RETURNING *
1058UPDATE "+table+" SET "+set+" WHERE "+field+"="+data['where'][field]+"
1059SELECT %s AS foo", (decimal.Decimal("19.10
1060SELECT %s AS foo", (decimal.Decimal("NaN
1061SELECT %s AS foo", (decimal.Decimal("infinity
1062SELECT %s AS foo", (decimal.Decimal("-infinity
1063SELECT %s AS foo", (float("nan
1064select 'inf'::float
1065SELECT %s AS foo", (float("inf
1066SELECT %s AS foo", (float("-inf
1067select col from array_test where id = 1
1068select col from array_test where id = 2
1069SELECT '{}' AS foo
1070SELECT '{}'::text[] AS foo
1071SELECT '{}'::text AS foo
1072select '{1, 2, 3}'::int4[]
1073select array['a', 'b', '''']::text[]
1074select '{1, 2, 3}'::int4[]
1075select '{1, 2, NULL}'::int4[]
1076select '{192.168.0.1/24}'::inet[]
1077select '{192.168.0.0/24}'::cidr[]
1078select '{10:20:30:40:50:60}'::macaddr[]
1079SELECT %s AS foo", (decimal.Decimal("19.10
1080SELECT %s AS foo", (decimal.Decimal("NaN
1081SELECT %s AS foo", (decimal.Decimal("infinity
1082SELECT %s AS foo", (decimal.Decimal("-infinity
1083SELECT %s AS foo", (float("nan
1084select 'inf'::float
1085SELECT %s AS foo", (float("inf
1086SELECT %s AS foo", (float("-inf
1087select col from array_test where id = 1
1088select col from array_test where id = 2
1089SELECT '{}' AS foo
1090SELECT '{}'::text[] AS foo
1091SELECT '{}'::text AS foo
1092select '{1, 2, 3}'::int4[]
1093select array['a', 'b', '''']::text[]
1094select '{1, 2, 3}'::int4[]
1095select '{1, 2, NULL}'::int4[]
1096select '{192.168.0.1/24}'::inet[]
1097select '{192.168.0.0/24}'::cidr[]
1098select '{10:20:30:40:50:60}'::macaddr[]
1099SELECT %s AS foo", (decimal.Decimal("19.10
1100SELECT %s AS foo", (decimal.Decimal("NaN
1101SELECT %s AS foo", (decimal.Decimal("infinity
1102SELECT %s AS foo", (decimal.Decimal("-infinity
1103SELECT %s AS foo", (float("nan
1104select 'inf'::float
1105SELECT %s AS foo", (float("inf
1106SELECT %s AS foo", (float("-inf
1107select col from array_test where id = 1
1108select col from array_test where id = 2
1109SELECT '{}' AS foo
1110SELECT '{}'::text[] AS foo
1111SELECT '{}'::text AS foo
1112select '{1, 2, 3}'::int4[]
1113select array['a', 'b', '''']::text[]
1114select '{1, 2, 3}'::int4[]
1115select '{1, 2, NULL}'::int4[]
1116select '{192.168.0.1/24}'::inet[]
1117select '{192.168.0.0/24}'::cidr[]
1118select '{10:20:30:40:50:60}'::macaddr[]
1119SELECT NULL::DECIMAL
1120SELECT NULL::DECIMAL
1121SELECT %s AS foo", (decimal.Decimal("19.10
1122SELECT %s AS foo", (decimal.Decimal("NaN
1123SELECT %s AS foo", (decimal.Decimal("infinity
1124SELECT %s AS foo", (decimal.Decimal("-infinity
1125SELECT %s AS foo", (float("nan
1126select 'inf'::float
1127SELECT %s AS foo", (float("inf
1128SELECT %s AS foo", (float("-inf
1129select col from array_test where id = 1
1130select col from array_test where id = 2
1131SELECT '{}' AS foo
1132SELECT '{}'::text[] AS foo
1133SELECT '{}'::text AS foo
1134select '{1, 2, 3}'::int4[]
1135select array['a', 'b', '''']::text[]
1136select '{1, 2, 3}'::int4[]
1137select '{1, 2, NULL}'::int4[]
1138select '{192.168.0.1/24}'::inet[]
1139select '{192.168.0.0/24}'::cidr[]
1140select '{10:20:30:40:50:60}'::macaddr[]
1141""SELECT * FROM waitingTable ""
1142SELECT namn, telnr, verified FROM producent
1143SELECT producent.telnr, email, namn, adress, verified FROM producent JOIN producentadress ON producent.telnr = producentadress.telnr
1144SELECT konsument.email, fnamn, enamn, telnr FROM konsument JOIN konsumenttelnr ON konsument.email = konsumenttelnr.email
1145SELECT * FROM artikel ORDER BY id DESC
1146SELECT note('hi there')
1147SELECT note('another note')
1148show client_encoding
1149show client_encoding
1150CREATE SEQUENCE fooseq
1151drop table speedy_users
1152SELECT %s AS foo", (decimal.Decimal("19.10
1153SELECT %s AS foo", (decimal.Decimal("NaN
1154SELECT %s AS foo", (decimal.Decimal("infinity
1155SELECT %s AS foo", (decimal.Decimal("-infinity
1156SELECT %s AS foo", (float("nan
1157select 'inf'::float
1158SELECT %s AS foo", (float("inf
1159SELECT %s AS foo", (float("-inf
1160select col from array_test where id = 1
1161select col from array_test where id = 2
1162SELECT '{}' AS foo
1163SELECT '{}'::text[] AS foo
1164SELECT '{}'::text AS foo
1165select '{1, 2, 3}'::int4[]
1166select array['a', 'b', '''']::text[]
1167select '{1, 2, 3}'::int4[]
1168select '{1, 2, NULL}'::int4[]
1169select '{192.168.0.1/24}'::inet[]
1170select '{192.168.0.0/24}'::cidr[]
1171select '{10:20:30:40:50:60}'::macaddr[]
1172select max(id) from logs2
1173delete from articles
1174""SELECT url FROM stations WHERE name='""" + station_name + """'""
1175""SELECT id FROM stations WHERE url='""" + file_path + """'""
1176""SELECT MIN(low_temp) FROM measures WHERE station_id=""" + str(station_id) + """ and m_date='""" + dts + """'""
1177""SELECT MAX(hi_temp) FROM measures WHERE station_id=""" + str(station_id) + """ and m_date='""" + dts + """'""
1178""SELECT AVG(temp_out) FROM measures WHERE station_id=""" + str(station_id) + """ and m_date='""" + dts + """'""
1179""SELECT SUM(rain) FROM measures WHERE station_id=""" + str(station_id) + """ and m_date='""" + dts + """'""
1180SELECT %s AS foo", (decimal.Decimal("19.10
1181SELECT %s AS foo", (decimal.Decimal("NaN
1182SELECT %s AS foo", (decimal.Decimal("infinity
1183SELECT %s AS foo", (decimal.Decimal("-infinity
1184SELECT %s AS foo", (float("nan
1185select 'inf'::float
1186SELECT %s AS foo", (float("inf
1187SELECT %s AS foo", (float("-inf
1188select col from array_test where id = 1
1189select col from array_test where id = 2
1190SELECT '{}' AS foo
1191SELECT '{}'::text[] AS foo
1192SELECT '{}'::text AS foo
1193select '{1, 2, 3}'::int4[]
1194select array['a', 'b', '''']::text[]
1195select '{1, 2, 3}'::int4[]
1196select '{1, 2, NULL}'::int4[]
1197select '{192.168.0.1/24}'::inet[]
1198select '{192.168.0.0/24}'::cidr[]
1199select '{10:20:30:40:50:60}'::macaddr[]
1200SELECT %s AS foo", (decimal.Decimal("19.10
1201SELECT %s AS foo", (decimal.Decimal("NaN
1202SELECT %s AS foo", (decimal.Decimal("infinity
1203SELECT %s AS foo", (decimal.Decimal("-infinity
1204SELECT %s AS foo", (float("nan
1205select 'inf'::float
1206SELECT %s AS foo", (float("inf
1207SELECT %s AS foo", (float("-inf
1208select col from array_test where id = 1
1209select col from array_test where id = 2
1210SELECT '{}' AS foo
1211SELECT '{}'::text[] AS foo
1212SELECT '{}'::text AS foo
1213select '{1, 2, 3}'::int4[]
1214select array['a', 'b', '''']::text[]
1215select '{1, 2, 3}'::int4[]
1216select '{1, 2, NULL}'::int4[]
1217select '{192.168.0.1/24}'::inet[]
1218select '{192.168.0.0/24}'::cidr[]
1219select '{10:20:30:40:50:60}'::macaddr[]
1220SELECT name, description FROM random_donald WHERE name = '" + name +"'
1221DELETE FROM random_donald WHERE name = '" + name + "'
1222SELECT name, description FROM random_donald WHERE name = '" + name + "'
1223SELECT name, description FROM random_donald ORDER BY RANDOM() LIMIT 1
1224SELECT %s AS foo", (decimal.Decimal("19.10
1225SELECT %s AS foo", (decimal.Decimal("NaN
1226SELECT %s AS foo", (decimal.Decimal("infinity
1227SELECT %s AS foo", (decimal.Decimal("-infinity
1228SELECT %s AS foo", (float("nan
1229select 'inf'::float
1230SELECT %s AS foo", (float("inf
1231SELECT %s AS foo", (float("-inf
1232select col from array_test where id = 1
1233select col from array_test where id = 2
1234SELECT '{}' AS foo
1235SELECT '{}'::text[] AS foo
1236SELECT '{}'::text AS foo
1237select '{1, 2, 3}'::int4[]
1238select array['a', 'b', '''']::text[]
1239select '{1, 2, 3}'::int4[]
1240select '{1, 2, NULL}'::int4[]
1241select '{192.168.0.1/24}'::inet[]
1242select '{192.168.0.0/24}'::cidr[]
1243select '{10:20:30:40:50:60}'::macaddr[]
1244Select pass from user1 where user_id='{}'
1245select name,user_id from subreddit order by subreddit_created_at desc
1246SELECT %s AS foo", (decimal.Decimal("19.10
1247SELECT %s AS foo", (decimal.Decimal("NaN
1248SELECT %s AS foo", (decimal.Decimal("infinity
1249SELECT %s AS foo", (decimal.Decimal("-infinity
1250SELECT %s AS foo", (float("nan
1251select 'inf'::float
1252SELECT %s AS foo", (float("inf
1253SELECT %s AS foo", (float("-inf
1254select col from array_test where id = 1
1255select col from array_test where id = 2
1256SELECT '{}' AS foo
1257SELECT '{}'::text[] AS foo
1258SELECT '{}'::text AS foo
1259select '{1, 2, 3}'::int4[]
1260select array['a', 'b', '''']::text[]
1261select '{1, 2, 3}'::int4[]
1262select '{1, 2, NULL}'::int4[]
1263select '{192.168.0.1/24}'::inet[]
1264select '{192.168.0.0/24}'::cidr[]
1265select '{10:20:30:40:50:60}'::macaddr[]
1266SELECT %s AS foo", (decimal.Decimal("19.10
1267SELECT %s AS foo", (decimal.Decimal("NaN
1268SELECT %s AS foo", (decimal.Decimal("infinity
1269SELECT %s AS foo", (decimal.Decimal("-infinity
1270SELECT %s AS foo", (float("nan
1271select 'inf'::float
1272SELECT %s AS foo", (float("inf
1273SELECT %s AS foo", (float("-inf
1274select col from array_test where id = 1
1275select col from array_test where id = 2
1276SELECT '{}' AS foo
1277SELECT '{}'::text[] AS foo
1278SELECT '{}'::text AS foo
1279select '{1, 2, 3}'::int4[]
1280select array['a', 'b', '''']::text[]
1281select '{1, 2, 3}'::int4[]
1282select '{1, 2, NULL}'::int4[]
1283select '{192.168.0.1/24}'::inet[]
1284select '{192.168.0.0/24}'::cidr[]
1285select '{10:20:30:40:50:60}'::macaddr[]
1286SELECT %s AS foo", (decimal.Decimal("19.10
1287SELECT %s AS foo", (decimal.Decimal("NaN
1288SELECT %s AS foo", (decimal.Decimal("infinity
1289SELECT %s AS foo", (decimal.Decimal("-infinity
1290SELECT %s AS foo", (float("nan
1291select 'inf'::float
1292SELECT %s AS foo", (float("inf
1293SELECT %s AS foo", (float("-inf
1294select col from array_test where id = 1
1295select col from array_test where id = 2
1296SELECT '{}' AS foo
1297SELECT '{}'::text[] AS foo
1298SELECT '{}'::text AS foo
1299select '{1, 2, 3}'::int4[]
1300select array['a', 'b', '''']::text[]
1301select '{1, 2, 3}'::int4[]
1302select '{1, 2, NULL}'::int4[]
1303select '{192.168.0.1/24}'::inet[]
1304select '{192.168.0.0/24}'::cidr[]
1305select '{10:20:30:40:50:60}'::macaddr[]
1306SELECT %s AS foo", (decimal.Decimal("19.10
1307SELECT %s AS foo", (decimal.Decimal("NaN
1308SELECT %s AS foo", (decimal.Decimal("infinity
1309SELECT %s AS foo", (decimal.Decimal("-infinity
1310SELECT %s AS foo", (float("nan
1311select 'inf'::float
1312SELECT %s AS foo", (float("inf
1313SELECT %s AS foo", (float("-inf
1314select col from array_test where id = 1
1315select col from array_test where id = 2
1316SELECT '{}' AS foo
1317SELECT '{}'::text[] AS foo
1318SELECT '{}'::text AS foo
1319select '{1, 2, 3}'::int4[]
1320select array['a', 'b', '''']::text[]
1321select '{1, 2, 3}'::int4[]
1322select '{1, 2, NULL}'::int4[]
1323select '{192.168.0.1/24}'::inet[]
1324select '{192.168.0.0/24}'::cidr[]
1325select '{10:20:30:40:50:60}'::macaddr[]
1326SELECT version FROM version
1327SELECT * FROM localcache
1328SAVEPOINT insert_savepoint
1329ROLLBACK TO SAVEPOINT insert_savepoint
1330SAVEPOINT update_savepoint
1331ROLLBACK TO SAVEPOINT update_savepoint
1332SAVEPOINT delete_savepoint
1333ROLLBACK TO SAVEPOINT delete_savepoint
1334select schema_name from information_schema.schemata
1335SELECT pg_try_advisory_lock(42)
1336SELECT pg_try_advisory_lock(42)
1337SELECT pg_advisory_unlock(42)
1338SELECT pg_advisory_unlock(42)
1339SELECT pg_advisory_unlock(42)
1340SELECT %s AS foo", (decimal.Decimal("19.10
1341SELECT %s AS foo", (decimal.Decimal("NaN
1342SELECT %s AS foo", (decimal.Decimal("infinity
1343SELECT %s AS foo", (decimal.Decimal("-infinity
1344SELECT %s AS foo", (float("nan
1345select 'inf'::float
1346SELECT %s AS foo", (float("inf
1347SELECT %s AS foo", (float("-inf
1348select col from array_test where id = 1
1349select col from array_test where id = 2
1350SELECT '{}' AS foo
1351SELECT '{}'::text[] AS foo
1352SELECT '{}'::text AS foo
1353select '{1, 2, 3}'::int4[]
1354select array['a', 'b', '''']::text[]
1355select '{1, 2, 3}'::int4[]
1356select '{1, 2, NULL}'::int4[]
1357select '{192.168.0.1/24}'::inet[]
1358select '{192.168.0.0/24}'::cidr[]
1359select '{10:20:30:40:50:60}'::macaddr[]
1360show client_encoding
1361show client_encoding
1362DELETE FROM urls_of_group
1363SELECT namn, telnr, verified FROM producent
1364SELECT producent.telnr, email, namn, adress, verified FROM producent JOIN producentadress ON producent.telnr = producentadress.telnr
1365SELECT konsument.email, fnamn, enamn, telnr FROM konsument JOIN konsumenttelnr ON konsument.email = konsumenttelnr.email
1366SELECT * FROM artikel ORDER BY id DESC
1367show client_encoding
1368show client_encoding
1369SELECT %s AS foo", (decimal.Decimal("19.10
1370SELECT %s AS foo", (decimal.Decimal("NaN
1371SELECT %s AS foo", (decimal.Decimal("infinity
1372SELECT %s AS foo", (decimal.Decimal("-infinity
1373SELECT %s AS foo", (float("nan
1374select 'inf'::float
1375SELECT %s AS foo", (float("inf
1376SELECT %s AS foo", (float("-inf
1377select col from array_test where id = 1
1378select col from array_test where id = 2
1379SELECT '{}' AS foo
1380SELECT '{}'::text[] AS foo
1381SELECT '{}'::text AS foo
1382select '{1, 2, 3}'::int4[]
1383select array['a', 'b', '''']::text[]
1384select '{1, 2, 3}'::int4[]
1385select '{1, 2, NULL}'::int4[]
1386select '{192.168.0.1/24}'::inet[]
1387select '{192.168.0.0/24}'::cidr[]
1388select '{10:20:30:40:50:60}'::macaddr[]
1389SELECT %s AS foo", (decimal.Decimal("19.10
1390SELECT %s AS foo", (decimal.Decimal("NaN
1391SELECT %s AS foo", (decimal.Decimal("infinity
1392SELECT %s AS foo", (decimal.Decimal("-infinity
1393SELECT %s AS foo", (float("nan
1394select 'inf'::float
1395SELECT %s AS foo", (float("inf
1396SELECT %s AS foo", (float("-inf
1397select col from array_test where id = 1
1398select col from array_test where id = 2
1399SELECT '{}' AS foo
1400SELECT '{}'::text[] AS foo
1401SELECT '{}'::text AS foo
1402select '{1, 2, 3}'::int4[]
1403select array['a', 'b', '''']::text[]
1404select '{1, 2, 3}'::int4[]
1405select '{1, 2, NULL}'::int4[]
1406select '{192.168.0.1/24}'::inet[]
1407select '{192.168.0.0/24}'::cidr[]
1408select '{10:20:30:40:50:60}'::macaddr[]
1409SELECT %s AS foo", (decimal.Decimal("19.10
1410SELECT %s AS foo", (decimal.Decimal("NaN
1411SELECT %s AS foo", (decimal.Decimal("infinity
1412SELECT %s AS foo", (decimal.Decimal("-infinity
1413SELECT %s AS foo", (float("nan
1414select 'inf'::float
1415SELECT %s AS foo", (float("inf
1416SELECT %s AS foo", (float("-inf
1417select col from array_test where id = 1
1418select col from array_test where id = 2
1419SELECT '{}' AS foo
1420SELECT '{}'::text[] AS foo
1421SELECT '{}'::text AS foo
1422select '{1, 2, 3}'::int4[]
1423select array['a', 'b', '''']::text[]
1424select '{1, 2, 3}'::int4[]
1425select '{1, 2, NULL}'::int4[]
1426select '{192.168.0.1/24}'::inet[]
1427select '{192.168.0.0/24}'::cidr[]
1428select '{10:20:30:40:50:60}'::macaddr[]
1429show client_encoding
1430show client_encoding
1431SELECT %s AS foo", (decimal.Decimal("19.10
1432SELECT %s AS foo", (decimal.Decimal("NaN
1433SELECT %s AS foo", (decimal.Decimal("infinity
1434SELECT %s AS foo", (decimal.Decimal("-infinity
1435SELECT %s AS foo", (float("nan
1436select 'inf'::float
1437SELECT %s AS foo", (float("inf
1438SELECT %s AS foo", (float("-inf
1439select col from array_test where id = 1
1440select col from array_test where id = 2
1441SELECT '{}' AS foo
1442SELECT '{}'::text[] AS foo
1443SELECT '{}'::text AS foo
1444select '{1, 2, 3}'::int4[]
1445select array['a', 'b', '''']::text[]
1446select '{1, 2, 3}'::int4[]
1447select '{1, 2, NULL}'::int4[]
1448select '{192.168.0.1/24}'::inet[]
1449select '{192.168.0.0/24}'::cidr[]
1450select '{10:20:30:40:50:60}'::macaddr[]
1451SELECT table_name FROM information_schema.tables WHERE table_schema='public' ORDER BY table_name
1452SELECT table_name FROM information_schema.tables WHERE table_schema='public'
1453SELECT oid, typname FROM pg_catalog.pg_type
1454SELECT %s AS foo", (decimal.Decimal("19.10
1455SELECT %s AS foo", (decimal.Decimal("NaN
1456SELECT %s AS foo", (decimal.Decimal("infinity
1457SELECT %s AS foo", (decimal.Decimal("-infinity
1458SELECT %s AS foo", (float("nan
1459select 'inf'::float
1460SELECT %s AS foo", (float("inf
1461SELECT %s AS foo", (float("-inf
1462select col from array_test where id = 1
1463select col from array_test where id = 2
1464SELECT '{}' AS foo
1465SELECT '{}'::text[] AS foo
1466SELECT '{}'::text AS foo
1467select '{1, 2, 3}'::int4[]
1468select array['a', 'b', '''']::text[]
1469select '{1, 2, 3}'::int4[]
1470select '{1, 2, NULL}'::int4[]
1471select '{192.168.0.1/24}'::inet[]
1472select '{192.168.0.0/24}'::cidr[]
1473select '{10:20:30:40:50:60}'::macaddr[]
1474show client_encoding
1475show client_encoding
1476DROP TABLE table1
1477DROP TABLE table2
1478INSERT INTO table1 VALUES (1, 'hello')
1479CREATE TABLE table2 (id int PRIMARY KEY)
1480DROP TABLE table1
1481DROP TABLE table2
1482LOCK table1 IN ACCESS EXCLUSIVE MODE
1483LOCK table2 IN ACCESS EXCLUSIVE MODE
1484LOCK table2 IN ACCESS EXCLUSIVE MODE
1485LOCK table1 IN ACCESS EXCLUSIVE MODE
1486SELECT name FROM table1 WHERE id = 1
1487UPDATE table1 SET name='task1' WHERE id = 1
1488UPDATE table1 SET name='task2' WHERE id = 1
1489""ALTER USER postgres WITH PASSWORD '';""
1490SELECT %s AS foo", (decimal.Decimal("19.10
1491SELECT %s AS foo", (decimal.Decimal("NaN
1492SELECT %s AS foo", (decimal.Decimal("infinity
1493SELECT %s AS foo", (decimal.Decimal("-infinity
1494SELECT %s AS foo", (float("nan
1495select 'inf'::float
1496SELECT %s AS foo", (float("inf
1497SELECT %s AS foo", (float("-inf
1498select col from array_test where id = 1
1499select col from array_test where id = 2
1500SELECT '{}' AS foo
1501SELECT '{}'::text[] AS foo
1502SELECT '{}'::text AS foo
1503select '{1, 2, 3}'::int4[]
1504select array['a', 'b', '''']::text[]
1505select '{1, 2, 3}'::int4[]
1506select '{1, 2, NULL}'::int4[]
1507select '{192.168.0.1/24}'::inet[]
1508select '{192.168.0.0/24}'::cidr[]
1509select '{10:20:30:40:50:60}'::macaddr[]
1510SELECT * FROM entity_types ORDER BY type;
1511SELECT %s AS foo", (decimal.Decimal("19.10
1512SELECT %s AS foo", (decimal.Decimal("NaN
1513SELECT %s AS foo", (decimal.Decimal("infinity
1514SELECT %s AS foo", (decimal.Decimal("-infinity
1515SELECT %s AS foo", (float("nan
1516select 'inf'::float
1517SELECT %s AS foo", (float("inf
1518SELECT %s AS foo", (float("-inf
1519select col from array_test where id = 1
1520select col from array_test where id = 2
1521SELECT '{}' AS foo
1522SELECT '{}'::text[] AS foo
1523SELECT '{}'::text AS foo
1524select '{1, 2, 3}'::int4[]
1525select array['a', 'b', '''']::text[]
1526select '{1, 2, 3}'::int4[]
1527select '{1, 2, NULL}'::int4[]
1528select '{192.168.0.1/24}'::inet[]
1529select '{192.168.0.0/24}'::cidr[]
1530select '{10:20:30:40:50:60}'::macaddr[]
1531SELECT %s AS foo", (decimal.Decimal("19.10
1532SELECT %s AS foo", (decimal.Decimal("NaN
1533SELECT %s AS foo", (decimal.Decimal("infinity
1534SELECT %s AS foo", (decimal.Decimal("-infinity
1535SELECT %s AS foo", (float("nan
1536select 'inf'::float
1537SELECT %s AS foo", (float("inf
1538SELECT %s AS foo", (float("-inf
1539select col from array_test where id = 1
1540select col from array_test where id = 2
1541SELECT '{}' AS foo
1542SELECT '{}'::text[] AS foo
1543SELECT '{}'::text AS foo
1544select '{1, 2, 3}'::int4[]
1545select array['a', 'b', '''']::text[]
1546select '{1, 2, 3}'::int4[]
1547select '{1, 2, NULL}'::int4[]
1548select '{192.168.0.1/24}'::inet[]
1549select '{192.168.0.0/24}'::cidr[]
1550select '{10:20:30:40:50:60}'::macaddr[]
1551BEGIN;
1552BEGIN;
1553BEGIN;
1554BEGIN;
1555SELECT %s AS foo", (decimal.Decimal("19.10
1556SELECT %s AS foo", (decimal.Decimal("NaN
1557SELECT %s AS foo", (decimal.Decimal("infinity
1558SELECT %s AS foo", (decimal.Decimal("-infinity
1559SELECT %s AS foo", (float("nan
1560select 'inf'::float
1561SELECT %s AS foo", (float("inf
1562SELECT %s AS foo", (float("-inf
1563select col from array_test where id = 1
1564select col from array_test where id = 2
1565SELECT '{}' AS foo
1566SELECT '{}'::text[] AS foo
1567SELECT '{}'::text AS foo
1568select '{1, 2, 3}'::int4[]
1569select array['a', 'b', '''']::text[]
1570select '{1, 2, 3}'::int4[]
1571select '{1, 2, NULL}'::int4[]
1572select '{192.168.0.1/24}'::inet[]
1573select '{192.168.0.0/24}'::cidr[]
1574select '{10:20:30:40:50:60}'::macaddr[]
1575SELECT * FROM movies
1576SELECT * FROM reviews LEFT JOIN movies ON reviews.movie_id = movies.id
1577DELETE FROM movies
1578DELETE FROM reviews
1579insert into Tasks VALUES(16, 'test', 'testt', 'test2')
1580UPDATE Tasks SET done = true WHERE id = 15
1581UPDATE Passwords SET password='" + password + "' WHERE email='" + self.email + "'
1582SELECT id, fname, lname, email, age, admin FROM Users WHERE email='" + email + "';
1583SELECT * FROM Users WHERE email='" + email + "';
1584SELECT * FROM Passwords WHERE email='" + email + "' AND password='" + password + "';
1585""SELECT regionid, regionname from region""
1586""SELECT personid, coment from persons""
1587select host from hosts where os='AIX'
1588select avg(value) from perfdata where host='"+row[0]+"' AND topic='LPAR' and metric='PhysicalCPU' and daytime>current_date-interval '1 day' and daytime<current_date
1589select avg(value) from perfdata where host='"+row[0]+"' AND topic='LPAR' and metric='PhysicalCPU' and daytime>current_date-interval '1 day'+ interval '9 hours' and daytime<current_date-interval'6 hours'
1590select avg(value) from perfdata where topic='MEM' and metric='Real total(MB)' and host='"+row[0]+"' and daytime>current_date-interval '1 day' and daytime<current_date
1591select avg(avgcpu),avg(avgcpu9_18),avg(avgmem) from perfsum where host='"+row[0]+"' and date like'"+yestermonth+"__'
1592update perfsum set avgcpu="+str(avgcpu)+", avgcpu9_18="+str(avgcpu9_18)+", avgmem="+str(avgmem)+" where host='"+row[0]+"' and date='"+yestermonth+"'
1593select avg(avgcpu),avg(avgcpu9_18),avg(avgmem) from perfsum where host='"+row[0]+"' and date like'"+yesteryear+"__'
1594update perfsum set avgcpu="+str(avgcpu)+", avgcpu9_18="+str(avgcpu9_18)+", avgmem="+str(avgmem)+" where host='"+row[0]+"' and date='"+yesteryear+"'
1595SELECT DISTINCT gl_id FROM gl_sn;
1596SELECT DISTINCT * FROM gl_sn;
1597SELECT %s AS foo", (decimal.Decimal("19.10
1598SELECT %s AS foo", (decimal.Decimal("NaN
1599SELECT %s AS foo", (decimal.Decimal("infinity
1600SELECT %s AS foo", (decimal.Decimal("-infinity
1601SELECT %s AS foo", (float("nan
1602select 'inf'::float
1603SELECT %s AS foo", (float("inf
1604SELECT %s AS foo", (float("-inf
1605select col from array_test where id = 1
1606select col from array_test where id = 2
1607SELECT '{}' AS foo
1608SELECT '{}'::text[] AS foo
1609SELECT '{}'::text AS foo
1610select '{1, 2, 3}'::int4[]
1611select array['a', 'b', '''']::text[]
1612select '{1, 2, 3}'::int4[]
1613select '{1, 2, NULL}'::int4[]
1614select '{192.168.0.1/24}'::inet[]
1615select '{192.168.0.0/24}'::cidr[]
1616select '{10:20:30:40:50:60}'::macaddr[]
1617SELECT %s AS foo", (decimal.Decimal("19.10
1618SELECT %s AS foo", (decimal.Decimal("NaN
1619SELECT %s AS foo", (decimal.Decimal("infinity
1620SELECT %s AS foo", (decimal.Decimal("-infinity
1621SELECT %s AS foo", (float("nan
1622select 'inf'::float
1623SELECT %s AS foo", (float("inf
1624SELECT %s AS foo", (float("-inf
1625select col from array_test where id = 1
1626select col from array_test where id = 2
1627SELECT '{}' AS foo
1628SELECT '{}'::text[] AS foo
1629SELECT '{}'::text AS foo
1630select '{1, 2, 3}'::int4[]
1631select array['a', 'b', '''']::text[]
1632select '{1, 2, 3}'::int4[]
1633select '{1, 2, NULL}'::int4[]
1634select '{192.168.0.1/24}'::inet[]
1635select '{192.168.0.0/24}'::cidr[]
1636select '{10:20:30:40:50:60}'::macaddr[]
1637show client_encoding
1638show client_encoding
1639CREATE TABLE IF NOT EXISTS store(item TEXT, Quantity INTEGER, Price REAL)
1640INSERT INTO store VALUES ('Wine Glass',8, 10.5)
1641SELECT * FROM store
1642CREATE TABLE IF NOT EXISTS store(item TEXT, Quantity INTEGER, Price REAL)
1643SELECT * FROM store
1644CREATE TABLE wards (id serial PRIMARY KEY, ward_num int)
1645CREATE TABLE beats (id serial PRIMARY KEY, beat_code varchar)
1646CREATE TABLE crime_type (id serial PRIMARY KEY, iucr varchar, primary_desc varchar)
1647CREATE TABLE crime (crime_id int PRIMARY KEY, case_number varchar, beat_id int, arrest bool, domestic bool, community_area int, block varchar, year int, date timestamp, fbi_code varchar, crime_type_id int, description varchar, location geometry(POINT, 4326), location_desc text, ward varchar)
1648ALTER TABLE communities ADD (housing_crowded numeric, households_below_poverty numeric, percent_aged_25_without_hs_diploma numeric, per_capita_income int, harship_index int)
1649SELECT %s AS foo", (decimal.Decimal("19.10
1650SELECT %s AS foo", (decimal.Decimal("NaN
1651SELECT %s AS foo", (decimal.Decimal("infinity
1652SELECT %s AS foo", (decimal.Decimal("-infinity
1653SELECT %s AS foo", (float("nan
1654select 'inf'::float
1655SELECT %s AS foo", (float("inf
1656SELECT %s AS foo", (float("-inf
1657select col from array_test where id = 1
1658select col from array_test where id = 2
1659SELECT '{}' AS foo
1660SELECT '{}'::text[] AS foo
1661SELECT '{}'::text AS foo
1662select '{1, 2, 3}'::int4[]
1663select array['a', 'b', '''']::text[]
1664select '{1, 2, 3}'::int4[]
1665select '{1, 2, NULL}'::int4[]
1666select '{192.168.0.1/24}'::inet[]
1667select '{192.168.0.0/24}'::cidr[]
1668select '{10:20:30:40:50:60}'::macaddr[]
1669SELECT count(*) FROM snapshots WHERE status in ('wait', 'doing');
1670SELECT %s AS foo", (decimal.Decimal("19.10
1671SELECT %s AS foo", (decimal.Decimal("NaN
1672SELECT %s AS foo", (decimal.Decimal("infinity
1673SELECT %s AS foo", (decimal.Decimal("-infinity
1674SELECT %s AS foo", (float("nan
1675select 'inf'::float
1676SELECT %s AS foo", (float("inf
1677SELECT %s AS foo", (float("-inf
1678create table array_test (id integer, col timestamp without time zone[])
1679select col from array_test where id = 1
1680select col from array_test where id = 2
1681SELECT '{}' AS foo
1682SELECT '{}'::text[] AS foo
1683SELECT '{}'::text AS foo
1684select '{1,2,3}'::int4[]
1685select array['a','b','''']::text[]
1686select '{1,2,3}'::int4[]
1687select '{1,2,NULL}'::int4[]
1688SELECT %s AS foo", (decimal.Decimal("19.10
1689SELECT %s AS foo", (decimal.Decimal("NaN
1690SELECT %s AS foo", (decimal.Decimal("infinity
1691SELECT %s AS foo", (decimal.Decimal("-infinity
1692SELECT %s AS foo", (float("nan
1693select 'inf'::float
1694SELECT %s AS foo", (float("inf
1695SELECT %s AS foo", (float("-inf
1696select col from array_test where id = 1
1697select col from array_test where id = 2
1698SELECT '{}' AS foo
1699SELECT '{}'::text[] AS foo
1700SELECT '{}'::text AS foo
1701select '{1, 2, 3}'::int4[]
1702select array['a', 'b', '''']::text[]
1703select '{1, 2, 3}'::int4[]
1704select '{1, 2, NULL}'::int4[]
1705select '{192.168.0.1/24}'::inet[]
1706select '{192.168.0.0/24}'::cidr[]
1707select '{10:20:30:40:50:60}'::macaddr[]
1708SELECT DISTINCT accio FROM esdeveniment
1709SELECT COUNT(*) FROM esdeveniment WHERE accio='"+accio+"'
1710SELECT DISTINCT accio FROM esdeveniment WHERE metge_id='M"+str(i)+"'
1711INSERT INTO metge (metge_id, especialitat) VALUES ('M"+str(i)+"','"+especialitat+"');
1712SELECT COUNT(*) FROM esdeveniment  WHERE accio='"+especialitat+"'
1713SELECT DISTINCT accio FROM esdeveniment
1714SELECT COUNT(DISTINCT  metge_id)  FROM esdeveniment WHERE  accio='"+accio+"'
1715SELECT COUNT(*)  FROM esdeveniment WHERE  accio='"+accio+"'
1716SELECT %s AS foo", (decimal.Decimal("19.10
1717SELECT %s AS foo", (decimal.Decimal("NaN
1718SELECT %s AS foo", (decimal.Decimal("infinity
1719SELECT %s AS foo", (decimal.Decimal("-infinity
1720SELECT %s AS foo", (float("nan
1721select 'inf'::float
1722SELECT %s AS foo", (float("inf
1723SELECT %s AS foo", (float("-inf
1724select col from array_test where id = 1
1725select col from array_test where id = 2
1726SELECT '{}' AS foo
1727SELECT '{}'::text[] AS foo
1728SELECT '{}'::text AS foo
1729select '{1, 2, 3}'::int4[]
1730select array['a', 'b', '''']::text[]
1731select '{1, 2, 3}'::int4[]
1732select '{1, 2, NULL}'::int4[]
1733select '{192.168.0.1/24}'::inet[]
1734select '{192.168.0.0/24}'::cidr[]
1735select '{10:20:30:40:50:60}'::macaddr[]
1736SELECT %s AS foo", (decimal.Decimal("19.10
1737SELECT %s AS foo", (decimal.Decimal("NaN
1738SELECT %s AS foo", (decimal.Decimal("infinity
1739SELECT %s AS foo", (decimal.Decimal("-infinity
1740SELECT %s AS foo", (float("nan
1741select 'inf'::float
1742SELECT %s AS foo", (float("inf
1743SELECT %s AS foo", (float("-inf
1744select col from array_test where id = 1
1745select col from array_test where id = 2
1746SELECT '{}' AS foo
1747SELECT '{}'::text[] AS foo
1748SELECT '{}'::text AS foo
1749select '{1, 2, 3}'::int4[]
1750select array['a', 'b', '''']::text[]
1751select '{1, 2, 3}'::int4[]
1752select '{1, 2, NULL}'::int4[]
1753select '{192.168.0.1/24}'::inet[]
1754select '{192.168.0.0/24}'::cidr[]
1755select '{10:20:30:40:50:60}'::macaddr[]
1756SELECT %s AS foo", (decimal.Decimal("19.10
1757SELECT %s AS foo", (decimal.Decimal("NaN
1758SELECT %s AS foo", (decimal.Decimal("infinity
1759SELECT %s AS foo", (decimal.Decimal("-infinity
1760SELECT %s AS foo", (float("nan
1761select 'inf'::float
1762SELECT %s AS foo", (float("inf
1763SELECT %s AS foo", (float("-inf
1764select col from array_test where id = 1
1765select col from array_test where id = 2
1766SELECT '{}' AS foo
1767SELECT '{}'::text[] AS foo
1768SELECT '{}'::text AS foo
1769select '{1, 2, 3}'::int4[]
1770select array['a', 'b', '''']::text[]
1771select '{1, 2, 3}'::int4[]
1772select '{1, 2, NULL}'::int4[]
1773select '{192.168.0.1/24}'::inet[]
1774select '{192.168.0.0/24}'::cidr[]
1775select '{10:20:30:40:50:60}'::macaddr[]
1776SELECT column_name FROM information_schema.columns WHERE table_schema = 'public' AND table_name='"+table+"'
1777INSERT INTO "+table+" "+column+" VALUES "+value+" RETURNING *
1778UPDATE "+table+" SET "+set+" WHERE "+field+"="+data['where'][field]+"
1779SELECT * FROM items ORDER BY id ASC
1780SELECT %s AS foo", (decimal.Decimal("19.10
1781SELECT %s AS foo", (decimal.Decimal("NaN
1782SELECT %s AS foo", (decimal.Decimal("infinity
1783SELECT %s AS foo", (decimal.Decimal("-infinity
1784SELECT %s AS foo", (float("nan
1785select 'inf'::float
1786SELECT %s AS foo", (float("inf
1787SELECT %s AS foo", (float("-inf
1788create table array_test (id integer, col timestamp without time zone[])
1789select col from array_test where id = 1
1790select col from array_test where id = 2
1791SELECT '{}' AS foo
1792SELECT '{}'::text[] AS foo
1793SELECT '{}'::text AS foo
1794select '{1,2,3}'::int4[]
1795select array['a','b','''']::text[]
1796select '{1,2,3}'::int4[]
1797select '{1,2,NULL}'::int4[]
1798SELECT %s AS foo", (decimal.Decimal("19.10
1799SELECT %s AS foo", (decimal.Decimal("NaN
1800SELECT %s AS foo", (decimal.Decimal("infinity
1801SELECT %s AS foo", (decimal.Decimal("-infinity
1802SELECT %s AS foo", (float("nan
1803select 'inf'::float
1804SELECT %s AS foo", (float("inf
1805SELECT %s AS foo", (float("-inf
1806select col from array_test where id = 1
1807select col from array_test where id = 2
1808SELECT '{}' AS foo
1809SELECT '{}'::text[] AS foo
1810SELECT '{}'::text AS foo
1811select '{1, 2, 3}'::int4[]
1812select array['a', 'b', '''']::text[]
1813select '{1, 2, 3}'::int4[]
1814select '{1, 2, NULL}'::int4[]
1815select '{192.168.0.1/24}'::inet[]
1816select '{192.168.0.0/24}'::cidr[]
1817select '{10:20:30:40:50:60}'::macaddr[]
1818SELECT * FROM cliente;
1819SELECT %s AS foo", (decimal.Decimal("19.10
1820SELECT %s AS foo", (decimal.Decimal("NaN
1821SELECT %s AS foo", (decimal.Decimal("infinity
1822SELECT %s AS foo", (decimal.Decimal("-infinity
1823SELECT %s AS foo", (float("nan
1824select 'inf'::float
1825SELECT %s AS foo", (float("inf
1826SELECT %s AS foo", (float("-inf
1827select col from array_test where id = 1
1828select col from array_test where id = 2
1829SELECT '{}' AS foo
1830SELECT '{}'::text[] AS foo
1831SELECT '{}'::text AS foo
1832select '{1, 2, 3}'::int4[]
1833select array['a', 'b', '''']::text[]
1834select '{1, 2, 3}'::int4[]
1835select '{1, 2, NULL}'::int4[]
1836select '{192.168.0.1/24}'::inet[]
1837select '{192.168.0.0/24}'::cidr[]
1838select '{10:20:30:40:50:60}'::macaddr[]
1839SELECT %s AS foo", (decimal.Decimal("19.10
1840SELECT %s AS foo", (decimal.Decimal("NaN
1841SELECT %s AS foo", (decimal.Decimal("infinity
1842SELECT %s AS foo", (decimal.Decimal("-infinity
1843SELECT %s AS foo", (float("nan
1844select 'inf'::float
1845SELECT %s AS foo", (float("inf
1846SELECT %s AS foo", (float("-inf
1847select col from array_test where id = 1
1848select col from array_test where id = 2
1849SELECT '{}' AS foo
1850SELECT '{}'::text[] AS foo
1851SELECT '{}'::text AS foo
1852select '{1, 2, 3}'::int4[]
1853select array['a', 'b', '''']::text[]
1854select '{1, 2, 3}'::int4[]
1855select '{1, 2, NULL}'::int4[]
1856select '{192.168.0.1/24}'::inet[]
1857select '{192.168.0.0/24}'::cidr[]
1858select '{10:20:30:40:50:60}'::macaddr[]
1859SELECT %s AS foo", (decimal.Decimal("19.10
1860SELECT %s AS foo", (decimal.Decimal("NaN
1861SELECT %s AS foo", (decimal.Decimal("infinity
1862SELECT %s AS foo", (decimal.Decimal("-infinity
1863SELECT %s AS foo", (float("nan
1864select 'inf'::float
1865SELECT %s AS foo", (float("inf
1866SELECT %s AS foo", (float("-inf
1867select col from array_test where id = 1
1868select col from array_test where id = 2
1869SELECT '{}' AS foo
1870SELECT '{}'::text[] AS foo
1871SELECT '{}'::text AS foo
1872select '{1, 2, 3}'::int4[]
1873select array['a', 'b', '''']::text[]
1874select '{1, 2, 3}'::int4[]
1875select '{1, 2, NULL}'::int4[]
1876select '{192.168.0.1/24}'::inet[]
1877select '{192.168.0.0/24}'::cidr[]
1878select '{10:20:30:40:50:60}'::macaddr[]
1879SELECT * FROM usuario
1880SELECT %s AS foo", (decimal.Decimal("19.10
1881SELECT %s AS foo", (decimal.Decimal("NaN
1882SELECT %s AS foo", (decimal.Decimal("infinity
1883SELECT %s AS foo", (decimal.Decimal("-infinity
1884SELECT %s AS foo", (float("nan
1885select 'inf'::float
1886SELECT %s AS foo", (float("inf
1887SELECT %s AS foo", (float("-inf
1888create table array_test (id integer, col timestamp without time zone[])
1889select col from array_test where id = 1
1890select col from array_test where id = 2
1891SELECT '{}' AS foo
1892SELECT '{}'::text[] AS foo
1893SELECT '{}'::text AS foo
1894select '{1,2,3}'::int4[]
1895select array['a','b','''']::text[]
1896select '{1,2,3}'::int4[]
1897select '{1,2,NULL}'::int4[]
1898select t.id from (select distinct app_project.id, app_project.created_at, row_number() over(order by app_project.created_at desc) as rn from app_project join auth_user on app_project.owner_id=auth_user.id where auth_user.email='" + email + "' and app_project.deleting=false)t where t.rn =1;
1899select username from auth_user where email='" + email + "';
1900select status from app_task where id='" + taskID + "';
1901select project_id from app_task where id='" + taskId + "'
1902select id from app_task where status=20
1903select distinct email from auth_user join app_project on auth_user.id=app_project.owner_id join app_task on app_project.id=app_task.project_id where app_task.id='"+taskId+"'
1904select distinct app_project.id from app_project join auth_user on app_project.owner_id=auth_user.id where auth_user.email='"+ email +"' and app_project.deleting=false
1905select t.id from (select app_project.id, app_project.created_at, row_number() over(order by app_project.created_at desc) from app_project join auth_user on app_project.owner_id=auth_user.id where app_project.name='" + projectName + "' and auth_user.email='" + email + "' and app_project.deleting=false)t where t.row_number=1
1906SELECT t.team_name, t.team_id, t.founded, tl.city, tl.state_prov FROM team t, team_loc tl WHERE tl.city_id = t.team_city_id
1907SELECT p.player_id, p.fname, p.lname, p.team_id, t.team_name, p.pos_id FROM player p, team t WHERE p.team_id = t.team_id ORDER BY p.lname ASC
1908SELECT t.team_name, t.founded, tl.team_city, tl.state_prov FROM team t, team_loc tl WHERE tl.city_id = t.team_city_id
1909SELECT t.team_name, t.founded, tl.team_city, tl.state_prov FROM team t, team_loc tl WHERE tl.city_id = t.team_city_id
1910SELECT * FROM english_words
1911UPDATE wordlist SET path_audio = '" + path_audio + '.mp3' + "' WHERE en_word = '" + path_audio + "' RETURNING path_audio;
1912UPDATE users_wordlist SET count_repeat = '" + str(count_repeat_of_word) + "' WHERE word_id = '" + str(word_id) + "'AND user_id = '" + str(user_id) + "' RETURNING count_repeat;
1913SELECT %s AS foo", (decimal.Decimal("19.10
1914SELECT %s AS foo", (decimal.Decimal("NaN
1915SELECT %s AS foo", (decimal.Decimal("infinity
1916SELECT %s AS foo", (decimal.Decimal("-infinity
1917SELECT %s AS foo", (float("nan
1918select 'inf'::float
1919SELECT %s AS foo", (float("inf
1920SELECT %s AS foo", (float("-inf
1921create table array_test (id integer, col timestamp without time zone[])
1922select col from array_test where id = 1
1923select col from array_test where id = 2
1924SELECT '{}' AS foo
1925SELECT '{}'::text[] AS foo
1926SELECT '{}'::text AS foo
1927select '{1,2,3}'::int4[]
1928select array['a','b','''']::text[]
1929select '{1,2,3}'::int4[]
1930select '{1,2,NULL}'::int4[]
1931SELECT %s AS foo", (decimal.Decimal("19.10
1932SELECT %s AS foo", (decimal.Decimal("NaN
1933SELECT %s AS foo", (decimal.Decimal("infinity
1934SELECT %s AS foo", (decimal.Decimal("-infinity
1935SELECT %s AS foo", (float("nan
1936select 'inf'::float
1937SELECT %s AS foo", (float("inf
1938SELECT %s AS foo", (float("-inf
1939select col from array_test where id = 1
1940select col from array_test where id = 2
1941SELECT '{}' AS foo
1942SELECT '{}'::text[] AS foo
1943SELECT '{}'::text AS foo
1944select '{1, 2, 3}'::int4[]
1945select array['a', 'b', '''']::text[]
1946select '{1, 2, 3}'::int4[]
1947select '{1, 2, NULL}'::int4[]
1948select '{192.168.0.1/24}'::inet[]
1949select '{192.168.0.0/24}'::cidr[]
1950select '{10:20:30:40:50:60}'::macaddr[]
1951SELECT ID, UserID from USERS
1952SELECT ID, UserID from USERS
1953SELECT ID, UserID from USERS
1954DELETE from USERS where ID = " + str(id_) + ";
1955SELECT ID, Name, UserID, Messages, Credits, Choice, Level from USERS
1956SELECT ID, UserID, Messages from USERS
1957SELECT ID, UserID, Credits from USERS
1958SELECT ID, UserID, DateOfLastCredit, Credits from USERS
1959SELECT ID, UserID, DateOfLastCredit from USERS
1960SELECT ID, UserID, Name from USERS
1961SELECT UserID, Level from USERS
1962SELECT UserID, Credits from USERS
1963SELECT UserID, Messages from USERS
1964SELECT UserID, Choice from USERS
1965SELECT UserID, Messages from USERS
1966SELECT UserID, Messages from USERS
1967SELECT ID, UserID, Level, Messages from USERS
1968SELECT ID, UserID, Credits, Choice, bought from USERS
1969SELECT ID, UserID, bought from USERS
1970SELECT ID, UserID from USERS
1971SELECT ID, UserID, subscribed from USERS
1972SELECT ID, UserID, subscribed from USERS
1973SELECT timestamp FROM " + table + " ORDER BY timestamp DESC LIMIT 1
1974SELECT timestamp FROM " + table + " ORDER BY timestamp DESC LIMIT 1
1975SELECT * FROM hero
1976SELECT * FROM karte
1977Select * from karte Join hero on hero.id = karte.class ;
1978SELECT * FROM deck
1979Select * from hero
1980Select * from hero
1981Select * from hero
1982Select * from hero
1983SELECT %s AS foo", (decimal.Decimal("19.10
1984SELECT %s AS foo", (decimal.Decimal("NaN
1985SELECT %s AS foo", (decimal.Decimal("infinity
1986SELECT %s AS foo", (decimal.Decimal("-infinity
1987SELECT %s AS foo", (float("nan
1988select 'inf'::float
1989SELECT %s AS foo", (float("inf
1990SELECT %s AS foo", (float("-inf
1991create table array_test (id integer, col timestamp without time zone[])
1992select col from array_test where id = 1
1993select col from array_test where id = 2
1994SELECT '{}' AS foo
1995SELECT '{}'::text[] AS foo
1996SELECT '{}'::text AS foo
1997select '{1,2,3}'::int4[]
1998select array['a','b','''']::text[]
1999select '{1,2,3}'::int4[]
2000select '{1,2,NULL}'::int4[]
2001SELECT %s AS foo", (decimal.Decimal("19.10
2002SELECT %s AS foo", (decimal.Decimal("NaN
2003SELECT %s AS foo", (decimal.Decimal("infinity
2004SELECT %s AS foo", (decimal.Decimal("-infinity
2005SELECT %s AS foo", (float("nan
2006select 'inf'::float
2007SELECT %s AS foo", (float("inf
2008SELECT %s AS foo", (float("-inf
2009select col from array_test where id = 1
2010select col from array_test where id = 2
2011SELECT '{}' AS foo
2012SELECT '{}'::text[] AS foo
2013SELECT '{}'::text AS foo
2014select '{1, 2, 3}'::int4[]
2015select array['a', 'b', '''']::text[]
2016select '{1, 2, 3}'::int4[]
2017select '{1, 2, NULL}'::int4[]
2018select '{192.168.0.1/24}'::inet[]
2019select '{192.168.0.0/24}'::cidr[]
2020select '{10:20:30:40:50:60}'::macaddr[]
2021SELECT %s AS foo", (decimal.Decimal("19.10
2022SELECT %s AS foo", (decimal.Decimal("NaN
2023SELECT %s AS foo", (decimal.Decimal("infinity
2024SELECT %s AS foo", (decimal.Decimal("-infinity
2025SELECT %s AS foo", (float("nan
2026select 'inf'::float
2027SELECT %s AS foo", (float("inf
2028SELECT %s AS foo", (float("-inf
2029create table array_test (id integer, col timestamp without time zone[])
2030select col from array_test where id = 1
2031select col from array_test where id = 2
2032SELECT '{}' AS foo
2033SELECT '{}'::text[] AS foo
2034SELECT '{}'::text AS foo
2035select '{1,2,3}'::int4[]
2036select array['a','b','''']::text[]
2037select '{1,2,3}'::int4[]
2038select '{1,2,NULL}'::int4[]
2039SELECT %s AS foo", (decimal.Decimal("19.10
2040SELECT %s AS foo", (decimal.Decimal("NaN
2041SELECT %s AS foo", (decimal.Decimal("infinity
2042SELECT %s AS foo", (decimal.Decimal("-infinity
2043SELECT %s AS foo", (float("nan
2044select 'inf'::float
2045SELECT %s AS foo", (float("inf
2046SELECT %s AS foo", (float("-inf
2047select col from array_test where id = 1
2048select col from array_test where id = 2
2049SELECT '{}' AS foo
2050SELECT '{}'::text[] AS foo
2051SELECT '{}'::text AS foo
2052select '{1, 2, 3}'::int4[]
2053select array['a', 'b', '''']::text[]
2054select '{1, 2, 3}'::int4[]
2055select '{1, 2, NULL}'::int4[]
2056select '{192.168.0.1/24}'::inet[]
2057select '{192.168.0.0/24}'::cidr[]
2058select '{10:20:30:40:50:60}'::macaddr[]
2059SELECT %s AS foo", (decimal.Decimal("19.10
2060SELECT %s AS foo", (decimal.Decimal("NaN
2061SELECT %s AS foo", (decimal.Decimal("infinity
2062SELECT %s AS foo", (decimal.Decimal("-infinity
2063SELECT %s AS foo", (float("nan
2064select 'inf'::float
2065SELECT %s AS foo", (float("inf
2066SELECT %s AS foo", (float("-inf
2067create table array_test (id integer, col timestamp without time zone[])
2068select col from array_test where id = 1
2069select col from array_test where id = 2
2070SELECT '{}' AS foo
2071SELECT '{}'::text[] AS foo
2072SELECT '{}'::text AS foo
2073select '{1,2,3}'::int4[]
2074select array['a','b','''']::text[]
2075select '{1,2,3}'::int4[]
2076select '{1,2,NULL}'::int4[]
2077ROLLBACK
2078SELECT 1
2079SELECT %s AS foo", (decimal.Decimal("19.10
2080SELECT %s AS foo", (decimal.Decimal("NaN
2081SELECT %s AS foo", (decimal.Decimal("infinity
2082SELECT %s AS foo", (decimal.Decimal("-infinity
2083SELECT %s AS foo", (float("nan
2084select 'inf'::float
2085SELECT %s AS foo", (float("inf
2086SELECT %s AS foo", (float("-inf
2087select col from array_test where id = 1
2088select col from array_test where id = 2
2089SELECT '{}' AS foo
2090SELECT '{}'::text[] AS foo
2091SELECT '{}'::text AS foo
2092select '{1, 2, 3}'::int4[]
2093select array['a', 'b', '''']::text[]
2094select '{1, 2, 3}'::int4[]
2095select '{1, 2, NULL}'::int4[]
2096select '{192.168.0.1/24}'::inet[]
2097select '{192.168.0.0/24}'::cidr[]
2098select '{10:20:30:40:50:60}'::macaddr[]
2099SELECT %s AS foo", (decimal.Decimal("19.10
2100SELECT %s AS foo", (decimal.Decimal("NaN
2101SELECT %s AS foo", (decimal.Decimal("infinity
2102SELECT %s AS foo", (decimal.Decimal("-infinity
2103SELECT %s AS foo", (float("nan
2104select 'inf'::float
2105SELECT %s AS foo", (float("inf
2106SELECT %s AS foo", (float("-inf
2107select col from array_test where id = 1
2108select col from array_test where id = 2
2109SELECT '{}' AS foo
2110SELECT '{}'::text[] AS foo
2111SELECT '{}'::text AS foo
2112select '{1, 2, 3}'::int4[]
2113select array['a', 'b', '''']::text[]
2114select '{1, 2, 3}'::int4[]
2115select '{1, 2, NULL}'::int4[]
2116select '{192.168.0.1/24}'::inet[]
2117select '{192.168.0.0/24}'::cidr[]
2118select '{10:20:30:40:50:60}'::macaddr[]
2119SELECT name FROM primary_domains
2120SELECT %s AS foo", (decimal.Decimal("19.10
2121SELECT %s AS foo", (decimal.Decimal("NaN
2122SELECT %s AS foo", (decimal.Decimal("infinity
2123SELECT %s AS foo", (decimal.Decimal("-infinity
2124SELECT %s AS foo", (float("nan
2125select 'inf'::float
2126SELECT %s AS foo", (float("inf
2127SELECT %s AS foo", (float("-inf
2128create table array_test (id integer, col timestamp without time zone[])
2129select col from array_test where id = 1
2130select col from array_test where id = 2
2131SELECT '{}' AS foo
2132SELECT '{}'::text[] AS foo
2133SELECT '{}'::text AS foo
2134select '{1,2,3}'::int4[]
2135select array['a','b','''']::text[]
2136select '{1,2,3}'::int4[]
2137select '{1,2,NULL}'::int4[]
2138SELECT * FROM user_info
2139SELECT %s AS foo", (decimal.Decimal("19.10
2140SELECT %s AS foo", (decimal.Decimal("NaN
2141SELECT %s AS foo", (decimal.Decimal("infinity
2142SELECT %s AS foo", (decimal.Decimal("-infinity
2143SELECT %s AS foo", (float("nan
2144select 'inf'::float
2145SELECT %s AS foo", (float("inf
2146SELECT %s AS foo", (float("-inf
2147create table array_test (id integer, col timestamp without time zone[])
2148select col from array_test where id = 1
2149select col from array_test where id = 2
2150SELECT '{}' AS foo
2151SELECT '{}'::text[] AS foo
2152SELECT '{}'::text AS foo
2153select '{1,2,3}'::int4[]
2154select array['a','b','''']::text[]
2155select '{1,2,3}'::int4[]
2156select '{1,2,NULL}'::int4[]
2157SELECT %s AS foo", (decimal.Decimal("19.10
2158SELECT %s AS foo", (decimal.Decimal("NaN
2159SELECT %s AS foo", (decimal.Decimal("infinity
2160SELECT %s AS foo", (decimal.Decimal("-infinity
2161SELECT %s AS foo", (float("nan
2162select 'inf'::float
2163SELECT %s AS foo", (float("inf
2164SELECT %s AS foo", (float("-inf
2165select col from array_test where id = 1
2166select col from array_test where id = 2
2167SELECT '{}' AS foo
2168SELECT '{}'::text[] AS foo
2169SELECT '{}'::text AS foo
2170select '{1, 2, 3}'::int4[]
2171select array['a', 'b', '''']::text[]
2172select '{1, 2, 3}'::int4[]
2173select '{1, 2, NULL}'::int4[]
2174select '{192.168.0.1/24}'::inet[]
2175select '{192.168.0.0/24}'::cidr[]
2176select '{10:20:30:40:50:60}'::macaddr[]
2177SELECT %s AS foo", (decimal.Decimal("19.10
2178SELECT %s AS foo", (decimal.Decimal("NaN
2179SELECT %s AS foo", (decimal.Decimal("infinity
2180SELECT %s AS foo", (decimal.Decimal("-infinity
2181SELECT %s AS foo", (float("nan
2182select 'inf'::float
2183SELECT %s AS foo", (float("inf
2184SELECT %s AS foo", (float("-inf
2185select col from array_test where id = 1
2186select col from array_test where id = 2
2187SELECT '{}' AS foo
2188SELECT '{}'::text[] AS foo
2189SELECT '{}'::text AS foo
2190select '{1, 2, 3}'::int4[]
2191select array['a', 'b', '''']::text[]
2192select '{1, 2, 3}'::int4[]
2193select '{1, 2, NULL}'::int4[]
2194select '{192.168.0.1/24}'::inet[]
2195select '{192.168.0.0/24}'::cidr[]
2196select '{10:20:30:40:50:60}'::macaddr[]
2197SELECT COUNT(*) FROM forums
2198DELETE FROM forums
2199SELECT %s AS foo", (decimal.Decimal("19.10
2200SELECT %s AS foo", (decimal.Decimal("NaN
2201SELECT %s AS foo", (decimal.Decimal("infinity
2202SELECT %s AS foo", (decimal.Decimal("-infinity
2203SELECT %s AS foo", (float("nan
2204select 'inf'::float
2205SELECT %s AS foo", (float("inf
2206SELECT %s AS foo", (float("-inf
2207select col from array_test where id = 1
2208select col from array_test where id = 2
2209SELECT '{}' AS foo
2210SELECT '{}'::text[] AS foo
2211SELECT '{}'::text AS foo
2212select '{1, 2, 3}'::int4[]
2213select array['a', 'b', '''']::text[]
2214select '{1, 2, 3}'::int4[]
2215select '{1, 2, NULL}'::int4[]
2216select '{192.168.0.1/24}'::inet[]
2217select '{192.168.0.0/24}'::cidr[]
2218select '{10:20:30:40:50:60}'::macaddr[]
2219SELECT %s AS foo", (decimal.Decimal("19.10
2220SELECT %s AS foo", (decimal.Decimal("NaN
2221SELECT %s AS foo", (decimal.Decimal("infinity
2222SELECT %s AS foo", (decimal.Decimal("-infinity
2223SELECT %s AS foo", (float("nan
2224select 'inf'::float
2225SELECT %s AS foo", (float("inf
2226SELECT %s AS foo", (float("-inf
2227create table array_test (id integer, col timestamp without time zone[])
2228select col from array_test where id = 1
2229select col from array_test where id = 2
2230SELECT '{}' AS foo
2231SELECT '{}'::text[] AS foo
2232SELECT '{}'::text AS foo
2233select '{1,2,3}'::int4[]
2234select array['a','b','''']::text[]
2235select '{1,2,3}'::int4[]
2236select '{1,2,NULL}'::int4[]
2237SELECT %s AS foo", (decimal.Decimal("19.10
2238SELECT %s AS foo", (decimal.Decimal("NaN
2239SELECT %s AS foo", (decimal.Decimal("infinity
2240SELECT %s AS foo", (decimal.Decimal("-infinity
2241SELECT %s AS foo", (float("nan
2242select 'inf'::float
2243SELECT %s AS foo", (float("inf
2244SELECT %s AS foo", (float("-inf
2245select col from array_test where id = 1
2246select col from array_test where id = 2
2247SELECT '{}' AS foo
2248SELECT '{}'::text[] AS foo
2249SELECT '{}'::text AS foo
2250select '{1, 2, 3}'::int4[]
2251select array['a', 'b', '''']::text[]
2252select '{1, 2, 3}'::int4[]
2253select '{1, 2, NULL}'::int4[]
2254select '{192.168.0.1/24}'::inet[]
2255select '{192.168.0.0/24}'::cidr[]
2256select '{10:20:30:40:50:60}'::macaddr[]
2257SELECT %s AS foo", (decimal.Decimal("19.10
2258SELECT %s AS foo", (decimal.Decimal("NaN
2259SELECT %s AS foo", (decimal.Decimal("infinity
2260SELECT %s AS foo", (decimal.Decimal("-infinity
2261SELECT %s AS foo", (float("nan
2262select 'inf'::float
2263SELECT %s AS foo", (float("inf
2264SELECT %s AS foo", (float("-inf
2265select col from array_test where id = 1
2266select col from array_test where id = 2
2267SELECT '{}' AS foo
2268SELECT '{}'::text[] AS foo
2269SELECT '{}'::text AS foo
2270select '{1, 2, 3}'::int4[]
2271select array['a', 'b', '''']::text[]
2272select '{1, 2, 3}'::int4[]
2273select '{1, 2, NULL}'::int4[]
2274select '{192.168.0.1/24}'::inet[]
2275select '{192.168.0.0/24}'::cidr[]
2276select '{10:20:30:40:50:60}'::macaddr[]
2277SELECT %s AS foo", (decimal.Decimal("19.10
2278SELECT %s AS foo", (decimal.Decimal("NaN
2279SELECT %s AS foo", (decimal.Decimal("infinity
2280SELECT %s AS foo", (decimal.Decimal("-infinity
2281SELECT %s AS foo", (float("nan
2282select 'inf'::float
2283SELECT %s AS foo", (float("inf
2284SELECT %s AS foo", (float("-inf
2285create table array_test (id integer, col timestamp without time zone[])
2286select col from array_test where id = 1
2287select col from array_test where id = 2
2288SELECT '{}' AS foo
2289SELECT '{}'::text[] AS foo
2290SELECT '{}'::text AS foo
2291select '{1,2,3}'::int4[]
2292select array['a','b','''']::text[]
2293select '{1,2,3}'::int4[]
2294select '{1,2,NULL}'::int4[]
2295SELECT %s AS foo", (decimal.Decimal("19.10
2296SELECT %s AS foo", (decimal.Decimal("NaN
2297SELECT %s AS foo", (decimal.Decimal("infinity
2298SELECT %s AS foo", (decimal.Decimal("-infinity
2299SELECT %s AS foo", (float("nan
2300select 'inf'::float
2301SELECT %s AS foo", (float("inf
2302SELECT %s AS foo", (float("-inf
2303create table array_test (id integer, col timestamp without time zone[])
2304select col from array_test where id = 1
2305select col from array_test where id = 2
2306SELECT '{}' AS foo
2307SELECT '{}'::text[] AS foo
2308SELECT '{}'::text AS foo
2309select '{1,2,3}'::int4[]
2310select array['a','b','''']::text[]
2311select '{1,2,3}'::int4[]
2312select '{1,2,NULL}'::int4[]
2313SELECT %s AS foo", (decimal.Decimal("19.10
2314SELECT %s AS foo", (decimal.Decimal("NaN
2315SELECT %s AS foo", (decimal.Decimal("infinity
2316SELECT %s AS foo", (decimal.Decimal("-infinity
2317SELECT %s AS foo", (float("nan
2318select 'inf'::float
2319SELECT %s AS foo", (float("inf
2320SELECT %s AS foo", (float("-inf
2321select col from array_test where id = 1
2322select col from array_test where id = 2
2323SELECT '{}' AS foo
2324SELECT '{}'::text[] AS foo
2325SELECT '{}'::text AS foo
2326select '{1, 2, 3}'::int4[]
2327select array['a', 'b', '''']::text[]
2328select '{1, 2, 3}'::int4[]
2329select '{1, 2, NULL}'::int4[]
2330select '{192.168.0.1/24}'::inet[]
2331select '{192.168.0.0/24}'::cidr[]
2332select '{10:20:30:40:50:60}'::macaddr[]
2333SELECT %s AS foo", (decimal.Decimal("19.10
2334SELECT %s AS foo", (decimal.Decimal("NaN
2335SELECT %s AS foo", (decimal.Decimal("infinity
2336SELECT %s AS foo", (decimal.Decimal("-infinity
2337SELECT %s AS foo", (float("nan
2338select 'inf'::float
2339SELECT %s AS foo", (float("inf
2340SELECT %s AS foo", (float("-inf
2341select col from array_test where id = 1
2342select col from array_test where id = 2
2343SELECT '{}' AS foo
2344SELECT '{}'::text[] AS foo
2345SELECT '{}'::text AS foo
2346select '{1, 2, 3}'::int4[]
2347select array['a', 'b', '''']::text[]
2348select '{1, 2, 3}'::int4[]
2349select '{1, 2, NULL}'::int4[]
2350select '{192.168.0.1/24}'::inet[]
2351select '{192.168.0.0/24}'::cidr[]
2352select '{10:20:30:40:50:60}'::macaddr[]
2353SELECT %s AS foo", (decimal.Decimal("19.10
2354SELECT %s AS foo", (decimal.Decimal("NaN
2355SELECT %s AS foo", (decimal.Decimal("infinity
2356SELECT %s AS foo", (decimal.Decimal("-infinity
2357SELECT %s AS foo", (float("nan
2358select 'inf'::float
2359SELECT %s AS foo", (float("inf
2360SELECT %s AS foo", (float("-inf
2361select col from array_test where id = 1
2362select col from array_test where id = 2
2363SELECT '{}' AS foo
2364SELECT '{}'::text[] AS foo
2365SELECT '{}'::text AS foo
2366select '{1, 2, 3}'::int4[]
2367select array['a', 'b', '''']::text[]
2368select '{1, 2, 3}'::int4[]
2369select '{1, 2, NULL}'::int4[]
2370select '{192.168.0.1/24}'::inet[]
2371select '{192.168.0.0/24}'::cidr[]
2372select '{10:20:30:40:50:60}'::macaddr[]
2373SELECT %s AS foo", (decimal.Decimal("19.10
2374SELECT %s AS foo", (decimal.Decimal("NaN
2375SELECT %s AS foo", (decimal.Decimal("infinity
2376SELECT %s AS foo", (decimal.Decimal("-infinity
2377SELECT %s AS foo", (float("nan
2378select 'inf'::float
2379SELECT %s AS foo", (float("inf
2380SELECT %s AS foo", (float("-inf
2381select col from array_test where id = 1
2382select col from array_test where id = 2
2383SELECT '{}' AS foo
2384SELECT '{}'::text[] AS foo
2385SELECT '{}'::text AS foo
2386select '{1, 2, 3}'::int4[]
2387select array['a', 'b', '''']::text[]
2388select '{1, 2, 3}'::int4[]
2389select '{1, 2, NULL}'::int4[]
2390select '{192.168.0.1/24}'::inet[]
2391select '{192.168.0.0/24}'::cidr[]
2392select '{10:20:30:40:50:60}'::macaddr[]
2393select * from players order by id
2394select * from winLossPlayed where no_of_matches = 0
2395select losses.lossesID as id, name, wins.noOfWins as wins, losses.noOfLosses as losses, wins.noOfWins + noOfLosses as no_of_Matches from losses, wins, players where losses.lossesID = wins.winsID and players.id = losses.lossesID order by wins desc;
2396select * from winLossPlayed where no_of_Matches = (select min(no_of_Matches) from winLossPlayed);
2397create view winLossPlayed as select losses.lossesID as id, name, wins.noOfWins as wins, losses.noOfLosses as losses, wins.noOfWins+losses.noOfLosses as no_of_Matchesfrom losses, wins, players where losses.lossesID = wins.winsID and players.id = losses.lossesID order by wins desc;
2398SELECT %s AS foo", (decimal.Decimal("19.10
2399SELECT %s AS foo", (decimal.Decimal("NaN
2400SELECT %s AS foo", (decimal.Decimal("infinity
2401SELECT %s AS foo", (decimal.Decimal("-infinity
2402SELECT %s AS foo", (float("nan
2403select 'inf'::float
2404SELECT %s AS foo", (float("inf
2405SELECT %s AS foo", (float("-inf
2406create table array_test (id integer, col timestamp without time zone[])
2407select col from array_test where id = 1
2408select col from array_test where id = 2
2409SELECT '{}' AS foo
2410SELECT '{}'::text[] AS foo
2411SELECT '{}'::text AS foo
2412select '{1,2,3}'::int4[]
2413select array['a','b','''']::text[]
2414select '{1,2,3}'::int4[]
2415select '{1,2,NULL}'::int4[]
2416SELECT %s AS foo", (decimal.Decimal("19.10
2417SELECT %s AS foo", (decimal.Decimal("NaN
2418SELECT %s AS foo", (decimal.Decimal("infinity
2419SELECT %s AS foo", (decimal.Decimal("-infinity
2420SELECT %s AS foo", (float("nan
2421select 'inf'::float
2422SELECT %s AS foo", (float("inf
2423SELECT %s AS foo", (float("-inf
2424select col from array_test where id = 1
2425select col from array_test where id = 2
2426SELECT '{}' AS foo
2427SELECT '{}'::text[] AS foo
2428SELECT '{}'::text AS foo
2429select '{1, 2, 3}'::int4[]
2430select array['a', 'b', '''']::text[]
2431select '{1, 2, 3}'::int4[]
2432select '{1, 2, NULL}'::int4[]
2433select '{192.168.0.1/24}'::inet[]
2434select '{192.168.0.0/24}'::cidr[]
2435select '{10:20:30:40:50:60}'::macaddr[]
2436SELECT * FROM name_form;
2437SELECT * FROM name_form;
2438SELECT * FROM name_form;
2439CREATE TABLE IF NOT EXISTS customer_transactions (customer_id int, store_id int, spent numeric);
2440CREATE TABLE IF NOT EXISTS items_purchased (customer_id int, item_number int, item_name varchar);
2441CREATE TABLE IF NOT EXISTS store (store_id int, state varchar);
2442CREATE TABLE IF NOT EXISTS customer (customer_id int, name varchar, rewards boolean);
2443SELECT store_id, SUM(spent) FROM customer_transactions GROUP BY store_id;
2444DROP TABLE customer_transactions
2445SELECT * FROM current
2446SELECT * FROM puzzles
2447SELECT * FROM solved
2448DELETE FROM current
2449INSERT into solved (url) VALUES (\'" + handler.get_current_puzzle()[0] + "\')
2450DELETE FROM puzzles
2451select * from publiclog where tablen='drivers' order by otime
2452select * from drivers
2453select * from serieslog where tablen='runs' order by otime
2454select c.carid, c.classcode, d.firstname, d.lastname from drivers d JOIN cars c ON c.driverid=d.driverid
2455select * from serieslog where tablen='runorder' and action='U' order by otime
2456SELECT %s AS foo", (decimal.Decimal("19.10
2457SELECT %s AS foo", (decimal.Decimal("NaN
2458SELECT %s AS foo", (decimal.Decimal("infinity
2459SELECT %s AS foo", (decimal.Decimal("-infinity
2460SELECT %s AS foo", (float("nan
2461select 'inf'::float
2462SELECT %s AS foo", (float("inf
2463SELECT %s AS foo", (float("-inf
2464select col from array_test where id = 1
2465select col from array_test where id = 2
2466SELECT '{}' AS foo
2467SELECT '{}'::text[] AS foo
2468SELECT '{}'::text AS foo
2469select '{1, 2, 3}'::int4[]
2470select array['a', 'b', '''']::text[]
2471select '{1, 2, 3}'::int4[]
2472select '{1, 2, NULL}'::int4[]
2473select '{192.168.0.1/24}'::inet[]
2474select '{192.168.0.0/24}'::cidr[]
2475select '{10:20:30:40:50:60}'::macaddr[]
2476SELECT %s AS foo", (decimal.Decimal("19.10
2477SELECT %s AS foo", (decimal.Decimal("NaN
2478SELECT %s AS foo", (decimal.Decimal("infinity
2479SELECT %s AS foo", (decimal.Decimal("-infinity
2480SELECT %s AS foo", (float("nan
2481select 'inf'::float
2482SELECT %s AS foo", (float("inf
2483SELECT %s AS foo", (float("-inf
2484select col from array_test where id = 1
2485select col from array_test where id = 2
2486SELECT '{}' AS foo
2487SELECT '{}'::text[] AS foo
2488SELECT '{}'::text AS foo
2489select '{1, 2, 3}'::int4[]
2490select array['a', 'b', '''']::text[]
2491select '{1, 2, 3}'::int4[]
2492select '{1, 2, NULL}'::int4[]
2493select '{192.168.0.1/24}'::inet[]
2494select '{192.168.0.0/24}'::cidr[]
2495select '{10:20:30:40:50:60}'::macaddr[]
2496SELECT %s AS foo", (decimal.Decimal("19.10
2497SELECT %s AS foo", (decimal.Decimal("NaN
2498SELECT %s AS foo", (decimal.Decimal("infinity
2499SELECT %s AS foo", (decimal.Decimal("-infinity
2500SELECT %s AS foo", (float("nan
2501select 'inf'::float
2502SELECT %s AS foo", (float("inf
2503SELECT %s AS foo", (float("-inf
2504select col from array_test where id = 1
2505select col from array_test where id = 2
2506SELECT '{}' AS foo
2507SELECT '{}'::text[] AS foo
2508SELECT '{}'::text AS foo
2509select '{1, 2, 3}'::int4[]
2510select array['a', 'b', '''']::text[]
2511select '{1, 2, 3}'::int4[]
2512select '{1, 2, NULL}'::int4[]
2513select '{192.168.0.1/24}'::inet[]
2514select '{192.168.0.0/24}'::cidr[]
2515select '{10:20:30:40:50:60}'::macaddr[]
2516SELECT username FROM users
2517SELECT %s AS foo", (decimal.Decimal("19.10
2518SELECT %s AS foo", (decimal.Decimal("NaN
2519SELECT %s AS foo", (decimal.Decimal("infinity
2520SELECT %s AS foo", (decimal.Decimal("-infinity
2521SELECT %s AS foo", (float("nan
2522select 'inf'::float
2523SELECT %s AS foo", (float("inf
2524SELECT %s AS foo", (float("-inf
2525select col from array_test where id = 1
2526select col from array_test where id = 2
2527SELECT '{}' AS foo
2528SELECT '{}'::text[] AS foo
2529SELECT '{}'::text AS foo
2530select '{1, 2, 3}'::int4[]
2531select array['a', 'b', '''']::text[]
2532select '{1, 2, 3}'::int4[]
2533select '{1, 2, NULL}'::int4[]
2534select '{192.168.0.1/24}'::inet[]
2535select '{192.168.0.0/24}'::cidr[]
2536select '{10:20:30:40:50:60}'::macaddr[]
2537CREATE TABLE IF NOT EXISTS farming(general_date date ,screening text,cartel int ,dates text,looses int,actual int,paste int,weight int,poultry int,patch real,total_looses int,poultry_looses int,total_paste int)
2538SELECT * FROM farming
2539SELECT MAX(dates),MAX(gas_final),MAX(paste_final),MAX(poultry_final),MAX(straw_final),MAX(working_final),MAX(piastika_final),MAX(electricity_final),MAX(logistics_final),MAX(cleaning_final),MAX(disinfectant_final),MAX(injection_final),MAX(medicine_final),MAX(alimony_final),MAX(oil_final),MAX(total_spendings_final) FROM spendings
2540SELECT screening,dates,gas,straw,working,logistics,cleaning,disinfectant,injection,medicine,alimony,oil,waste FROM spendings
2541SELECT dates,value_incomes,waste_final,fpa,aggregate,fpa_debit,taxes,total_incomes,final_incomes,final_incomes_taxes FROM spendings
2542SELECT %s AS foo", (decimal.Decimal("19.10
2543SELECT %s AS foo", (decimal.Decimal("NaN
2544SELECT %s AS foo", (decimal.Decimal("infinity
2545SELECT %s AS foo", (decimal.Decimal("-infinity
2546SELECT %s AS foo", (float("nan
2547select 'inf'::float
2548SELECT %s AS foo", (float("inf
2549SELECT %s AS foo", (float("-inf
2550select col from array_test where id = 1
2551select col from array_test where id = 2
2552SELECT '{}' AS foo
2553SELECT '{}'::text[] AS foo
2554SELECT '{}'::text AS foo
2555select '{1, 2, 3}'::int4[]
2556select array['a', 'b', '''']::text[]
2557select '{1, 2, 3}'::int4[]
2558select '{1, 2, NULL}'::int4[]
2559select '{192.168.0.1/24}'::inet[]
2560select '{192.168.0.0/24}'::cidr[]
2561select '{10:20:30:40:50:60}'::macaddr[]
2562SELECT %s AS foo", (decimal.Decimal("19.10
2563SELECT %s AS foo", (decimal.Decimal("NaN
2564SELECT %s AS foo", (decimal.Decimal("infinity
2565SELECT %s AS foo", (decimal.Decimal("-infinity
2566SELECT %s AS foo", (float("nan
2567select 'inf'::float
2568SELECT %s AS foo", (float("inf
2569SELECT %s AS foo", (float("-inf
2570select col from array_test where id = 1
2571select col from array_test where id = 2
2572SELECT '{}' AS foo
2573SELECT '{}'::text[] AS foo
2574SELECT '{}'::text AS foo
2575select '{1, 2, 3}'::int4[]
2576select array['a', 'b', '''']::text[]
2577select '{1, 2, 3}'::int4[]
2578select '{1, 2, NULL}'::int4[]
2579select '{192.168.0.1/24}'::inet[]
2580select '{192.168.0.0/24}'::cidr[]
2581select '{10:20:30:40:50:60}'::macaddr[]
2582SELECT %s AS foo", (decimal.Decimal("19.10
2583SELECT %s AS foo", (decimal.Decimal("NaN
2584SELECT %s AS foo", (decimal.Decimal("infinity
2585SELECT %s AS foo", (decimal.Decimal("-infinity
2586SELECT %s AS foo", (float("nan
2587select 'inf'::float
2588SELECT %s AS foo", (float("inf
2589SELECT %s AS foo", (float("-inf
2590select col from array_test where id = 1
2591select col from array_test where id = 2
2592SELECT '{}' AS foo
2593SELECT '{}'::text[] AS foo
2594SELECT '{}'::text AS foo
2595select '{1, 2, 3}'::int4[]
2596select array['a', 'b', '''']::text[]
2597select '{1, 2, 3}'::int4[]
2598select '{1, 2, NULL}'::int4[]
2599select '{192.168.0.1/24}'::inet[]
2600select '{192.168.0.0/24}'::cidr[]
2601select '{10:20:30:40:50:60}'::macaddr[]
2602SELECT %s AS foo", (decimal.Decimal("19.10
2603SELECT %s AS foo", (decimal.Decimal("NaN
2604SELECT %s AS foo", (decimal.Decimal("infinity
2605SELECT %s AS foo", (decimal.Decimal("-infinity
2606SELECT %s AS foo", (float("nan
2607select 'inf'::float
2608SELECT %s AS foo", (float("inf
2609SELECT %s AS foo", (float("-inf
2610select col from array_test where id = 1
2611select col from array_test where id = 2
2612SELECT '{}' AS foo
2613SELECT '{}'::text[] AS foo
2614SELECT '{}'::text AS foo
2615select '{1, 2, 3}'::int4[]
2616select array['a', 'b', '''']::text[]
2617select '{1, 2, 3}'::int4[]
2618select '{1, 2, NULL}'::int4[]
2619select '{192.168.0.1/24}'::inet[]
2620select '{192.168.0.0/24}'::cidr[]
2621select '{10:20:30:40:50:60}'::macaddr[]
2622SELECT 'hstore'::regtype::oid
2623SHOW ALL
2624SELECT %s AS foo", (decimal.Decimal("19.10
2625SELECT %s AS foo", (decimal.Decimal("NaN
2626SELECT %s AS foo", (decimal.Decimal("infinity
2627SELECT %s AS foo", (decimal.Decimal("-infinity
2628SELECT %s AS foo", (float("nan
2629select 'inf'::float
2630SELECT %s AS foo", (float("inf
2631SELECT %s AS foo", (float("-inf
2632select col from array_test where id = 1
2633select col from array_test where id = 2
2634SELECT '{}' AS foo
2635SELECT '{}'::text[] AS foo
2636SELECT '{}'::text AS foo
2637select '{1, 2, 3}'::int4[]
2638select array['a', 'b', '''']::text[]
2639select '{1, 2, 3}'::int4[]
2640select '{1, 2, NULL}'::int4[]
2641select '{192.168.0.1/24}'::inet[]
2642select '{192.168.0.0/24}'::cidr[]
2643select '{10:20:30:40:50:60}'::macaddr[]
2644SELECT %s AS foo", (decimal.Decimal("19.10
2645SELECT %s AS foo", (decimal.Decimal("NaN
2646SELECT %s AS foo", (decimal.Decimal("infinity
2647SELECT %s AS foo", (decimal.Decimal("-infinity
2648SELECT %s AS foo", (float("nan
2649select 'inf'::float
2650SELECT %s AS foo", (float("inf
2651SELECT %s AS foo", (float("-inf
2652select col from array_test where id = 1
2653select col from array_test where id = 2
2654SELECT '{}' AS foo
2655SELECT '{}'::text[] AS foo
2656SELECT '{}'::text AS foo
2657select '{1, 2, 3}'::int4[]
2658select array['a', 'b', '''']::text[]
2659select '{1, 2, 3}'::int4[]
2660select '{1, 2, NULL}'::int4[]
2661select '{192.168.0.1/24}'::inet[]
2662select '{192.168.0.0/24}'::cidr[]
2663select '{10:20:30:40:50:60}'::macaddr[]
2664show client_encoding
2665show client_encoding
2666SELECT %s AS foo", (decimal.Decimal("19.10
2667SELECT %s AS foo", (decimal.Decimal("NaN
2668SELECT %s AS foo", (decimal.Decimal("infinity
2669SELECT %s AS foo", (decimal.Decimal("-infinity
2670SELECT %s AS foo", (float("nan
2671select 'inf'::float
2672SELECT %s AS foo", (float("inf
2673SELECT %s AS foo", (float("-inf
2674select col from array_test where id = 1
2675select col from array_test where id = 2
2676SELECT '{}' AS foo
2677SELECT '{}'::text[] AS foo
2678SELECT '{}'::text AS foo
2679select '{1, 2, 3}'::int4[]
2680select array['a', 'b', '''']::text[]
2681select '{1, 2, 3}'::int4[]
2682select '{1, 2, NULL}'::int4[]
2683select '{192.168.0.1/24}'::inet[]
2684select '{192.168.0.0/24}'::cidr[]
2685select '{10:20:30:40:50:60}'::macaddr[]
2686SELECT %s AS foo", (decimal.Decimal("19.10
2687SELECT %s AS foo", (decimal.Decimal("NaN
2688SELECT %s AS foo", (decimal.Decimal("infinity
2689SELECT %s AS foo", (decimal.Decimal("-infinity
2690SELECT %s AS foo", (float("nan
2691select 'inf'::float
2692SELECT %s AS foo", (float("inf
2693SELECT %s AS foo", (float("-inf
2694select col from array_test where id = 1
2695select col from array_test where id = 2
2696SELECT '{}' AS foo
2697SELECT '{}'::text[] AS foo
2698SELECT '{}'::text AS foo
2699select '{1, 2, 3}'::int4[]
2700select array['a', 'b', '''']::text[]
2701select '{1, 2, 3}'::int4[]
2702select '{1, 2, NULL}'::int4[]
2703select '{192.168.0.1/24}'::inet[]
2704select '{192.168.0.0/24}'::cidr[]
2705select '{10:20:30:40:50:60}'::macaddr[]
2706select ID from clients WHERE Active = 'TRUE'
2707select * from clients;
2708SELECT %s AS foo", (decimal.Decimal("19.10
2709SELECT %s AS foo", (decimal.Decimal("NaN
2710SELECT %s AS foo", (decimal.Decimal("infinity
2711SELECT %s AS foo", (decimal.Decimal("-infinity
2712SELECT %s AS foo", (float("nan
2713select 'inf'::float
2714SELECT %s AS foo", (float("inf
2715SELECT %s AS foo", (float("-inf
2716select col from array_test where id = 1
2717select col from array_test where id = 2
2718SELECT '{}' AS foo
2719SELECT '{}'::text[] AS foo
2720SELECT '{}'::text AS foo
2721select '{1, 2, 3}'::int4[]
2722select array['a', 'b', '''']::text[]
2723select '{1, 2, 3}'::int4[]
2724select '{1, 2, NULL}'::int4[]
2725select '{192.168.0.1/24}'::inet[]
2726select '{192.168.0.0/24}'::cidr[]
2727select '{10:20:30:40:50:60}'::macaddr[]
2728SELECT %s AS foo", (decimal.Decimal("19.10
2729SELECT %s AS foo", (decimal.Decimal("NaN
2730SELECT %s AS foo", (decimal.Decimal("infinity
2731SELECT %s AS foo", (decimal.Decimal("-infinity
2732SELECT %s AS foo", (float("nan
2733select 'inf'::float
2734SELECT %s AS foo", (float("inf
2735SELECT %s AS foo", (float("-inf
2736select col from array_test where id = 1
2737select col from array_test where id = 2
2738SELECT '{}' AS foo
2739SELECT '{}'::text[] AS foo
2740SELECT '{}'::text AS foo
2741select '{1, 2, 3}'::int4[]
2742select array['a', 'b', '''']::text[]
2743select '{1, 2, 3}'::int4[]
2744select '{1, 2, NULL}'::int4[]
2745select '{192.168.0.1/24}'::inet[]
2746select '{192.168.0.0/24}'::cidr[]
2747select '{10:20:30:40:50:60}'::macaddr[]
2748SELECT %s AS foo", (decimal.Decimal("19.10
2749SELECT %s AS foo", (decimal.Decimal("NaN
2750SELECT %s AS foo", (decimal.Decimal("infinity
2751SELECT %s AS foo", (decimal.Decimal("-infinity
2752SELECT %s AS foo", (float("nan
2753select 'inf'::float
2754SELECT %s AS foo", (float("inf
2755SELECT %s AS foo", (float("-inf
2756select col from array_test where id = 1
2757select col from array_test where id = 2
2758SELECT '{}' AS foo
2759SELECT '{}'::text[] AS foo
2760SELECT '{}'::text AS foo
2761select '{1, 2, 3}'::int4[]
2762select array['a', 'b', '''']::text[]
2763select '{1, 2, 3}'::int4[]
2764select '{1, 2, NULL}'::int4[]
2765select '{192.168.0.1/24}'::inet[]
2766select '{192.168.0.0/24}'::cidr[]
2767select '{10:20:30:40:50:60}'::macaddr[]
2768SELECT %s AS foo", (decimal.Decimal("19.10
2769SELECT %s AS foo", (decimal.Decimal("NaN
2770SELECT %s AS foo", (decimal.Decimal("infinity
2771SELECT %s AS foo", (decimal.Decimal("-infinity
2772SELECT %s AS foo", (float("nan
2773select 'inf'::float
2774SELECT %s AS foo", (float("inf
2775SELECT %s AS foo", (float("-inf
2776select col from array_test where id = 1
2777select col from array_test where id = 2
2778SELECT '{}' AS foo
2779SELECT '{}'::text[] AS foo
2780SELECT '{}'::text AS foo
2781select '{1, 2, 3}'::int4[]
2782select array['a', 'b', '''']::text[]
2783select '{1, 2, 3}'::int4[]
2784select '{1, 2, NULL}'::int4[]
2785select '{192.168.0.1/24}'::inet[]
2786select '{192.168.0.0/24}'::cidr[]
2787select '{10:20:30:40:50:60}'::macaddr[]
2788SELECT %s AS foo", (decimal.Decimal("19.10
2789SELECT %s AS foo", (decimal.Decimal("NaN
2790SELECT %s AS foo", (decimal.Decimal("infinity
2791SELECT %s AS foo", (decimal.Decimal("-infinity
2792SELECT %s AS foo", (float("nan
2793select 'inf'::float
2794SELECT %s AS foo", (float("inf
2795SELECT %s AS foo", (float("-inf
2796select col from array_test where id = 1
2797select col from array_test where id = 2
2798SELECT '{}' AS foo
2799SELECT '{}'::text[] AS foo
2800SELECT '{}'::text AS foo
2801select '{1, 2, 3}'::int4[]
2802select array['a', 'b', '''']::text[]
2803select '{1, 2, 3}'::int4[]
2804select '{1, 2, NULL}'::int4[]
2805select '{192.168.0.1/24}'::inet[]
2806select '{192.168.0.0/24}'::cidr[]
2807select '{10:20:30:40:50:60}'::macaddr[]
2808SELECT %s AS foo", (decimal.Decimal("19.10
2809SELECT %s AS foo", (decimal.Decimal("NaN
2810SELECT %s AS foo", (decimal.Decimal("infinity
2811SELECT %s AS foo", (decimal.Decimal("-infinity
2812SELECT %s AS foo", (float("nan
2813select 'inf'::float
2814SELECT %s AS foo", (float("inf
2815SELECT %s AS foo", (float("-inf
2816select col from array_test where id = 1
2817select col from array_test where id = 2
2818SELECT '{}' AS foo
2819SELECT '{}'::text[] AS foo
2820SELECT '{}'::text AS foo
2821select '{1, 2, 3}'::int4[]
2822select array['a', 'b', '''']::text[]
2823select '{1, 2, 3}'::int4[]
2824select '{1, 2, NULL}'::int4[]
2825select '{192.168.0.1/24}'::inet[]
2826select '{192.168.0.0/24}'::cidr[]
2827select '{10:20:30:40:50:60}'::macaddr[]
2828SELECT %s AS foo", (decimal.Decimal("19.10
2829SELECT %s AS foo", (decimal.Decimal("NaN
2830SELECT %s AS foo", (decimal.Decimal("infinity
2831SELECT %s AS foo", (decimal.Decimal("-infinity
2832SELECT %s AS foo", (float("nan
2833select 'inf'::float
2834SELECT %s AS foo", (float("inf
2835SELECT %s AS foo", (float("-inf
2836select col from array_test where id = 1
2837select col from array_test where id = 2
2838SELECT '{}' AS foo
2839SELECT '{}'::text[] AS foo
2840SELECT '{}'::text AS foo
2841select '{1, 2, 3}'::int4[]
2842select array['a', 'b', '''']::text[]
2843select '{1, 2, 3}'::int4[]
2844select '{1, 2, NULL}'::int4[]
2845select '{192.168.0.1/24}'::inet[]
2846select '{192.168.0.0/24}'::cidr[]
2847select '{10:20:30:40:50:60}'::macaddr[]
2848""EXPLAIN (FORMAT json) SELECT * FROM homeless_by_coc WHERE homeless_by_coc.id = 5;""
2849""EXPLAIN (FORMAT json) SELECT * FROM state_info WHERE state_info.name = 'Alabama';""
2850""EXPLAIN (FORMAT json) SELECT * FROM state_household_incomes WHERE state_household_incomes.state = 'Georgia';""
2851DROP TABLE state_idx
2852""SELECT h.state, h.year, h.coc_number FROM homeless_by_coc as h, state_idx WHERE state_idx.id = h.id AND state_idx.name = 'CA';""
2853""EXPLAIN (FORMAT json, ANALYZE) SELECT * FROM homeless_by_coc WHERE state = 'CA'""
2854""CREATE INDEX state_idx ON homeless_by_coc(state)""
2855""EXPLAIN (FORMAT json, ANALYZE) SELECT * FROM homeless_by_coc WHERE state = 'CA'""
2856DROP INDEX IF EXISTS state_idx
2857CREATE INDEX state_idx ON homeless_by_coc(state)
2858EXPLAIN (ANALYZE, format json) SELECT * FROM homeless_by_coc WHERE state='CA'
2859DROP INDEX IF EXISTS state_idx
2860EXPLAIN (ANALYZE, format json) SELECT * FROM homeless_by_coc WHERE state='CA'
2861DROP INDEX IF EXISTS state_idx
2862""EXPLAIN (FORMAT json, ANALYZE) SELECT hbc.state, hbc.coc_number, hbc.coc_name, si.name FROM homeless_by_coc as hbc, state_info as si WHERE hbc.state = si.postal""
2863CREATE INDEX state_idx ON homeless_by_coc(state)
2864""EXPLAIN (FORMAT json, ANALYZE) SELECT hbc.state, hbc.coc_number, hbc.coc_name, si.name FROM homeless_by_coc as hbc, state_info as si WHERE hbc.state = si.postal""
2865SELECT %s AS foo", (decimal.Decimal("19.10
2866SELECT %s AS foo", (decimal.Decimal("NaN
2867SELECT %s AS foo", (decimal.Decimal("infinity
2868SELECT %s AS foo", (decimal.Decimal("-infinity
2869SELECT %s AS foo", (float("nan
2870select 'inf'::float
2871SELECT %s AS foo", (float("inf
2872SELECT %s AS foo", (float("-inf
2873select col from array_test where id = 1
2874select col from array_test where id = 2
2875SELECT '{}' AS foo
2876SELECT '{}'::text[] AS foo
2877SELECT '{}'::text AS foo
2878select '{1, 2, 3}'::int4[]
2879select array['a', 'b', '''']::text[]
2880select '{1, 2, 3}'::int4[]
2881select '{1, 2, NULL}'::int4[]
2882select '{192.168.0.1/24}'::inet[]
2883select '{192.168.0.0/24}'::cidr[]
2884select '{10:20:30:40:50:60}'::macaddr[]
2885SELECT %s AS foo", (decimal.Decimal("19.10
2886SELECT %s AS foo", (decimal.Decimal("NaN
2887SELECT %s AS foo", (decimal.Decimal("infinity
2888SELECT %s AS foo", (decimal.Decimal("-infinity
2889SELECT %s AS foo", (float("nan
2890select 'inf'::float
2891SELECT %s AS foo", (float("inf
2892SELECT %s AS foo", (float("-inf
2893select col from array_test where id = 1
2894select col from array_test where id = 2
2895SELECT '{}' AS foo
2896SELECT '{}'::text[] AS foo
2897SELECT '{}'::text AS foo
2898select '{1, 2, 3}'::int4[]
2899select array['a', 'b', '''']::text[]
2900select '{1, 2, 3}'::int4[]
2901select '{1, 2, NULL}'::int4[]
2902select '{192.168.0.1/24}'::inet[]
2903select '{192.168.0.0/24}'::cidr[]
2904select '{10:20:30:40:50:60}'::macaddr[]
2905SELECT %s AS foo", (decimal.Decimal("19.10
2906SELECT %s AS foo", (decimal.Decimal("NaN
2907SELECT %s AS foo", (decimal.Decimal("infinity
2908SELECT %s AS foo", (decimal.Decimal("-infinity
2909SELECT %s AS foo", (float("nan
2910select 'inf'::float
2911SELECT %s AS foo", (float("inf
2912SELECT %s AS foo", (float("-inf
2913select col from array_test where id = 1
2914select col from array_test where id = 2
2915SELECT '{}' AS foo
2916SELECT '{}'::text[] AS foo
2917SELECT '{}'::text AS foo
2918select '{1, 2, 3}'::int4[]
2919select array['a', 'b', '''']::text[]
2920select '{1, 2, 3}'::int4[]
2921select '{1, 2, NULL}'::int4[]
2922select '{192.168.0.1/24}'::inet[]
2923select '{192.168.0.0/24}'::cidr[]
2924select '{10:20:30:40:50:60}'::macaddr[]
2925SELECT %s AS foo", (decimal.Decimal("19.10
2926SELECT %s AS foo", (decimal.Decimal("NaN
2927SELECT %s AS foo", (decimal.Decimal("infinity
2928SELECT %s AS foo", (decimal.Decimal("-infinity
2929SELECT %s AS foo", (float("nan
2930select 'inf'::float
2931SELECT %s AS foo", (float("inf
2932SELECT %s AS foo", (float("-inf
2933select col from array_test where id = 1
2934select col from array_test where id = 2
2935SELECT '{}' AS foo
2936SELECT '{}'::text[] AS foo
2937SELECT '{}'::text AS foo
2938select '{1, 2, 3}'::int4[]
2939select array['a', 'b', '''']::text[]
2940select '{1, 2, 3}'::int4[]
2941select '{1, 2, NULL}'::int4[]
2942select '{192.168.0.1/24}'::inet[]
2943select '{192.168.0.0/24}'::cidr[]
2944select '{10:20:30:40:50:60}'::macaddr[]
2945select * from borrowed
2946SELECT 'hstore'::regtype::oid
2947SHOW ALL
2948SELECT %s AS foo", (decimal.Decimal("19.10
2949SELECT %s AS foo", (decimal.Decimal("NaN
2950SELECT %s AS foo", (decimal.Decimal("infinity
2951SELECT %s AS foo", (decimal.Decimal("-infinity
2952SELECT %s AS foo", (float("nan
2953select 'inf'::float
2954SELECT %s AS foo", (float("inf
2955SELECT %s AS foo", (float("-inf
2956select col from array_test where id = 1
2957select col from array_test where id = 2
2958SELECT '{}' AS foo
2959SELECT '{}'::text[] AS foo
2960SELECT '{}'::text AS foo
2961select '{1, 2, 3}'::int4[]
2962select array['a', 'b', '''']::text[]
2963select '{1, 2, 3}'::int4[]
2964select '{1, 2, NULL}'::int4[]
2965select '{192.168.0.1/24}'::inet[]
2966select '{192.168.0.0/24}'::cidr[]
2967select '{10:20:30:40:50:60}'::macaddr[]
2968SELECT %s AS foo", (decimal.Decimal("19.10
2969SELECT %s AS foo", (decimal.Decimal("NaN
2970SELECT %s AS foo", (decimal.Decimal("infinity
2971SELECT %s AS foo", (decimal.Decimal("-infinity
2972SELECT %s AS foo", (float("nan
2973select 'inf'::float
2974SELECT %s AS foo", (float("inf
2975SELECT %s AS foo", (float("-inf
2976select col from array_test where id = 1
2977select col from array_test where id = 2
2978SELECT '{}' AS foo
2979SELECT '{}'::text[] AS foo
2980SELECT '{}'::text AS foo
2981select '{1, 2, 3}'::int4[]
2982select array['a', 'b', '''']::text[]
2983select '{1, 2, 3}'::int4[]
2984select '{1, 2, NULL}'::int4[]
2985select '{192.168.0.1/24}'::inet[]
2986select '{192.168.0.0/24}'::cidr[]
2987select '{10:20:30:40:50:60}'::macaddr[]
2988SELECT * FROM bar
2989SELECT * FROM bar
2990SELECT %s AS foo", (decimal.Decimal("19.10
2991SELECT %s AS foo", (decimal.Decimal("NaN
2992SELECT %s AS foo", (decimal.Decimal("infinity
2993SELECT %s AS foo", (decimal.Decimal("-infinity
2994SELECT %s AS foo", (float("nan
2995select 'inf'::float
2996SELECT %s AS foo", (float("inf
2997SELECT %s AS foo", (float("-inf
2998select col from array_test where id = 1
2999select col from array_test where id = 2
3000SELECT '{}' AS foo
3001SELECT '{}'::text[] AS foo
3002SELECT '{}'::text AS foo
3003select '{1, 2, 3}'::int4[]
3004select array['a', 'b', '''']::text[]
3005select '{1, 2, 3}'::int4[]
3006select '{1, 2, NULL}'::int4[]
3007select '{192.168.0.1/24}'::inet[]
3008select '{192.168.0.0/24}'::cidr[]
3009select '{10:20:30:40:50:60}'::macaddr[]
3010SELECT %s AS foo", (decimal.Decimal("19.10
3011SELECT %s AS foo", (decimal.Decimal("NaN
3012SELECT %s AS foo", (decimal.Decimal("infinity
3013SELECT %s AS foo", (decimal.Decimal("-infinity
3014SELECT %s AS foo", (float("nan
3015select 'inf'::float
3016SELECT %s AS foo", (float("inf
3017SELECT %s AS foo", (float("-inf
3018select col from array_test where id = 1
3019select col from array_test where id = 2
3020SELECT '{}' AS foo
3021SELECT '{}'::text[] AS foo
3022SELECT '{}'::text AS foo
3023select '{1, 2, 3}'::int4[]
3024select array['a', 'b', '''']::text[]
3025select '{1, 2, 3}'::int4[]
3026select '{1, 2, NULL}'::int4[]
3027select '{192.168.0.1/24}'::inet[]
3028select '{192.168.0.0/24}'::cidr[]
3029select '{10:20:30:40:50:60}'::macaddr[]
3030select to_char(now(), 'DD/MM/YYYY HH24:MI:SS') as date_
3031select product_id, name from products
3032select location_id, location_name from locations
3033SELECT %s AS foo", (decimal.Decimal("19.10
3034SELECT %s AS foo", (decimal.Decimal("NaN
3035SELECT %s AS foo", (decimal.Decimal("infinity
3036SELECT %s AS foo", (decimal.Decimal("-infinity
3037SELECT %s AS foo", (float("nan
3038select 'inf'::float
3039SELECT %s AS foo", (float("inf
3040SELECT %s AS foo", (float("-inf
3041select col from array_test where id = 1
3042select col from array_test where id = 2
3043SELECT '{}' AS foo
3044SELECT '{}'::text[] AS foo
3045SELECT '{}'::text AS foo
3046select '{1, 2, 3}'::int4[]
3047select array['a', 'b', '''']::text[]
3048select '{1, 2, 3}'::int4[]
3049select '{1, 2, NULL}'::int4[]
3050select '{192.168.0.1/24}'::inet[]
3051select '{192.168.0.0/24}'::cidr[]
3052select '{10:20:30:40:50:60}'::macaddr[]
3053SELECT %s AS foo", (decimal.Decimal("19.10
3054SELECT %s AS foo", (decimal.Decimal("NaN
3055SELECT %s AS foo", (decimal.Decimal("infinity
3056SELECT %s AS foo", (decimal.Decimal("-infinity
3057SELECT %s AS foo", (float("nan
3058select 'inf'::float
3059SELECT %s AS foo", (float("inf
3060SELECT %s AS foo", (float("-inf
3061create table array_test (id integer, col timestamp without time zone[])
3062select col from array_test where id = 1
3063select col from array_test where id = 2
3064SELECT '{}' AS foo
3065SELECT '{}'::text[] AS foo
3066SELECT '{}'::text AS foo
3067select '{1,2,3}'::int4[]
3068select array['a','b','''']::text[]
3069select '{1,2,3}'::int4[]
3070select '{1,2,NULL}'::int4[]
3071SELECT %s AS foo", (decimal.Decimal("19.10
3072SELECT %s AS foo", (decimal.Decimal("NaN
3073SELECT %s AS foo", (decimal.Decimal("infinity
3074SELECT %s AS foo", (decimal.Decimal("-infinity
3075SELECT %s AS foo", (float("nan
3076select 'inf'::float
3077SELECT %s AS foo", (float("inf
3078SELECT %s AS foo", (float("-inf
3079select col from array_test where id = 1
3080select col from array_test where id = 2
3081SELECT '{}' AS foo
3082SELECT '{}'::text[] AS foo
3083SELECT '{}'::text AS foo
3084select '{1, 2, 3}'::int4[]
3085select array['a', 'b', '''']::text[]
3086select '{1, 2, 3}'::int4[]
3087select '{1, 2, NULL}'::int4[]
3088select '{192.168.0.1/24}'::inet[]
3089select '{192.168.0.0/24}'::cidr[]
3090select '{10:20:30:40:50:60}'::macaddr[]
3091SELECT %s AS foo", (decimal.Decimal("19.10
3092SELECT %s AS foo", (decimal.Decimal("NaN
3093SELECT %s AS foo", (decimal.Decimal("infinity
3094SELECT %s AS foo", (decimal.Decimal("-infinity
3095SELECT %s AS foo", (float("nan
3096select 'inf'::float
3097SELECT %s AS foo", (float("inf
3098SELECT %s AS foo", (float("-inf
3099select col from array_test where id = 1
3100select col from array_test where id = 2
3101SELECT '{}' AS foo
3102SELECT '{}'::text[] AS foo
3103SELECT '{}'::text AS foo
3104select '{1, 2, 3}'::int4[]
3105select array['a', 'b', '''']::text[]
3106select '{1, 2, 3}'::int4[]
3107select '{1, 2, NULL}'::int4[]
3108select '{192.168.0.1/24}'::inet[]
3109select '{192.168.0.0/24}'::cidr[]
3110select '{10:20:30:40:50:60}'::macaddr[]
3111select username, concat(substring(tweet,1,100),'...') from tweet_data order by update_time desc limit 50
3112select * from tweet_analysis order by no desc limit 25
3113select post_url as url, substring(post_content,0,100) || '...' as content, post_title as id, post_date as date, subject, 1 as type from blog order by post_date desc limit 25
3114select count(*) from blog
3115SELECT %s AS foo", (decimal.Decimal("19.10
3116SELECT %s AS foo", (decimal.Decimal("NaN
3117SELECT %s AS foo", (decimal.Decimal("infinity
3118SELECT %s AS foo", (decimal.Decimal("-infinity
3119SELECT %s AS foo", (float("nan
3120select 'inf'::float
3121SELECT %s AS foo", (float("inf
3122SELECT %s AS foo", (float("-inf
3123select col from array_test where id = 1
3124select col from array_test where id = 2
3125SELECT '{}' AS foo
3126SELECT '{}'::text[] AS foo
3127SELECT '{}'::text AS foo
3128select '{1, 2, 3}'::int4[]
3129select array['a', 'b', '''']::text[]
3130select '{1, 2, 3}'::int4[]
3131select '{1, 2, NULL}'::int4[]
3132select '{192.168.0.1/24}'::inet[]
3133select '{192.168.0.0/24}'::cidr[]
3134select '{10:20:30:40:50:60}'::macaddr[]
3135show client_encoding
3136show client_encoding
3137SELECT %s AS foo", (decimal.Decimal("19.10
3138SELECT %s AS foo", (decimal.Decimal("NaN
3139SELECT %s AS foo", (decimal.Decimal("infinity
3140SELECT %s AS foo", (decimal.Decimal("-infinity
3141SELECT %s AS foo", (float("nan
3142select 'inf'::float
3143SELECT %s AS foo", (float("inf
3144SELECT %s AS foo", (float("-inf
3145select col from array_test where id = 1
3146select col from array_test where id = 2
3147SELECT '{}' AS foo
3148SELECT '{}'::text[] AS foo
3149SELECT '{}'::text AS foo
3150select '{1, 2, 3}'::int4[]
3151select array['a', 'b', '''']::text[]
3152select '{1, 2, 3}'::int4[]
3153select '{1, 2, NULL}'::int4[]
3154select '{192.168.0.1/24}'::inet[]
3155select '{192.168.0.0/24}'::cidr[]
3156select '{10:20:30:40:50:60}'::macaddr[]
3157SELECT %s AS foo", (decimal.Decimal("19.10
3158SELECT %s AS foo", (decimal.Decimal("NaN
3159SELECT %s AS foo", (decimal.Decimal("infinity
3160SELECT %s AS foo", (decimal.Decimal("-infinity
3161SELECT %s AS foo", (float("nan
3162select 'inf'::float
3163SELECT %s AS foo", (float("inf
3164SELECT %s AS foo", (float("-inf
3165create table array_test (id integer, col timestamp without time zone[])
3166select col from array_test where id = 1
3167select col from array_test where id = 2
3168SELECT '{}' AS foo
3169SELECT '{}'::text[] AS foo
3170SELECT '{}'::text AS foo
3171select '{1,2,3}'::int4[]
3172select array['a','b','''']::text[]
3173select '{1,2,3}'::int4[]
3174select '{1,2,NULL}'::int4[]
3175SELECT %s AS foo", (decimal.Decimal("19.10
3176SELECT %s AS foo", (decimal.Decimal("NaN
3177SELECT %s AS foo", (decimal.Decimal("infinity
3178SELECT %s AS foo", (decimal.Decimal("-infinity
3179SELECT %s AS foo", (float("nan
3180select 'inf'::float
3181SELECT %s AS foo", (float("inf
3182SELECT %s AS foo", (float("-inf
3183select col from array_test where id = 1
3184select col from array_test where id = 2
3185SELECT '{}' AS foo
3186SELECT '{}'::text[] AS foo
3187SELECT '{}'::text AS foo
3188select '{1, 2, 3}'::int4[]
3189select array['a', 'b', '''']::text[]
3190select '{1, 2, 3}'::int4[]
3191select '{1, 2, NULL}'::int4[]
3192select '{192.168.0.1/24}'::inet[]
3193select '{192.168.0.0/24}'::cidr[]
3194select '{10:20:30:40:50:60}'::macaddr[]
3195select last, first, userid, affiliation, username as email, ST_AsText(ST_Transform(location,4326)) as location from users where username = '" + username + "' and password = '" + password + "';
3196INSERT INTO users (first, last, affiliation, username, password, lastlogin, location) VALUES ('" + first + "', '" + last + "', '" + affiliation + "', '" + email + "', '" + password + "',  current_timestamp, ST_Transform(ST_SetSrid(ST_GeomFromText('" + location + "'), 4326),3857)) RETURNING last, first, userid, affiliation, username as email, ST_AsText(ST_Transform(location,4326)) as location;
3197UPDATE users set (first, last, affiliation, username, password, lastlogin, location) = ('" + first + "', '" + last + "', '" + affiliation + "', '" + email + "', '" + password + "',  current_timestamp, ST_Transform(ST_SetSrid(ST_GeomFromText('" + location + "'), 4326),3857)) where userid = " + userid + " RETURNING last, first, userid, affiliation, username as email, ST_AsText(ST_Transform(location,4326)) as location;
3198INSERT INTO questions (userid, question, type, hashtag, explain) VALUES (" + userid + ", '" + question + "', '" + qtype + "', '" + hashtag + "', '" + explain + "') RETURNING userid, question, type, hashtag, qid, explain;
3199INSERT INTO answers (qid, answer, color, link) VALUES (" + qid + ", '" + answer + "', '" + color + "', '" + link + "') RETURNING qid, answer, answerid, color, link
3200INSERT INTO responses (qid, answerid, response, location, locationwm) VALUES (" + qid + ", " + answerid + ", '" + uresponse + "', " + " ST_SetSrid(ST_GeomFromText('" + location + "'), 4326)" + ", ST_Transform(ST_SetSrid(ST_GeomFromText('" + location + "'), 4326),3857)) RETURNING qid, answerid, response, ST_AsText(ST_Transform(location,4326)) as location;
3201select * from (select * from answers where qid = " + qid + ") as a full join (select response, count(response) from responses where qid = " + qid + " group by response, answerid) as b on a.answer = b.response
3202select count(qid) from (select * from (select qid " + SQLMeat + ") as foo;
3203select qnum from (select qid, qid = " + firstq + " as tq, row_number() over(order by created DESC) as qnum,  to_char(created, 'YYYY-MM-DD HH24:MI:SS') as created " + SQLMeat + " where tq = true
3204select * from (select userid, question, type, hashtag, qid, COALESCE(explain, '') as explain, to_char(created, 'YYYY-MM-DD HH24:MI:SS') as created " + SQLMeat + " order by created DESC limit " + count + " offset " + str(offset) + ";
3205select * from (select userid, question, type, hashtag, qid, to_char(created, 'YYYY-MM-DD HH24:MI:SS') as created from questions where qid = " + qid + ") a " + ending + " where a.qid = " + qid + ";
3206select * from answers where qid = " + qid + ";
3207update answers as an set color = c.color from (select * from (select row_number() over (PARTITION by qid order by answerid) as id, qid, answer, answerid from answers order by qid, answerid) as a join colors as b on a.id = b.id) as c where an.answerid = c.answerid and an.qid = " + qid + ";
3208update answers as an set color = c.color from (select * from (select row_number() over (PARTITION by qid order by answerid) as id, qid, answer, answerid from answers order by qid, answerid) as a join colors as b on a.id = b.id) as c where an.answerid = c.answerid and an.qid = " + qid + " and an.color = ''
3209SELECT * from jugadores
3210SELECT * from jugadores
3211SELECT * from jugadores ORDER BY id ASC
3212SELECT * from jugadores ORDER BY puntos DESC, goles DESC, jugador ASC
3213SELECT * from jugadores ORDER BY goles DESC, jugador ASC
3214SELECT * from jugadores ORDER BY puntos DESC, goles DESC, jugador ASC
3215SELECT %s AS foo", (decimal.Decimal("19.10
3216SELECT %s AS foo", (decimal.Decimal("NaN
3217SELECT %s AS foo", (decimal.Decimal("infinity
3218SELECT %s AS foo", (decimal.Decimal("-infinity
3219SELECT %s AS foo", (float("nan
3220select 'inf'::float
3221SELECT %s AS foo", (float("inf
3222SELECT %s AS foo", (float("-inf
3223select col from array_test where id = 1
3224select col from array_test where id = 2
3225SELECT '{}' AS foo
3226SELECT '{}'::text[] AS foo
3227SELECT '{}'::text AS foo
3228select '{1, 2, 3}'::int4[]
3229select array['a', 'b', '''']::text[]
3230select '{1, 2, 3}'::int4[]
3231select '{1, 2, NULL}'::int4[]
3232select '{192.168.0.1/24}'::inet[]
3233select '{192.168.0.0/24}'::cidr[]
3234select '{10:20:30:40:50:60}'::macaddr[]
3235SELECT %s AS foo", (decimal.Decimal("19.10
3236SELECT %s AS foo", (decimal.Decimal("NaN
3237SELECT %s AS foo", (decimal.Decimal("infinity
3238SELECT %s AS foo", (decimal.Decimal("-infinity
3239SELECT %s AS foo", (float("nan
3240select 'inf'::float
3241SELECT %s AS foo", (float("inf
3242SELECT %s AS foo", (float("-inf
3243select col from array_test where id = 1
3244select col from array_test where id = 2
3245SELECT '{}' AS foo
3246SELECT '{}'::text[] AS foo
3247SELECT '{}'::text AS foo
3248select '{1, 2, 3}'::int4[]
3249select array['a', 'b', '''']::text[]
3250select '{1, 2, 3}'::int4[]
3251select '{1, 2, NULL}'::int4[]
3252select '{192.168.0.1/24}'::inet[]
3253select '{192.168.0.0/24}'::cidr[]
3254select '{10:20:30:40:50:60}'::macaddr[]
3255SELECT %s AS foo", (decimal.Decimal("19.10
3256SELECT %s AS foo", (decimal.Decimal("NaN
3257SELECT %s AS foo", (decimal.Decimal("infinity
3258SELECT %s AS foo", (decimal.Decimal("-infinity
3259SELECT %s AS foo", (float("nan
3260select 'inf'::float
3261SELECT %s AS foo", (float("inf
3262SELECT %s AS foo", (float("-inf
3263create table array_test (id integer, col timestamp without time zone[])
3264select col from array_test where id = 1
3265select col from array_test where id = 2
3266SELECT '{}' AS foo
3267SELECT '{}'::text[] AS foo
3268SELECT '{}'::text AS foo
3269select '{1,2,3}'::int4[]
3270select array['a','b','''']::text[]
3271select '{1,2,3}'::int4[]
3272select '{1,2,NULL}'::int4[]
3273SELECT %s AS foo", (decimal.Decimal("19.10
3274SELECT %s AS foo", (decimal.Decimal("NaN
3275SELECT %s AS foo", (decimal.Decimal("infinity
3276SELECT %s AS foo", (decimal.Decimal("-infinity
3277SELECT %s AS foo", (float("nan
3278select 'inf'::float
3279SELECT %s AS foo", (float("inf
3280SELECT %s AS foo", (float("-inf
3281select col from array_test where id = 1
3282select col from array_test where id = 2
3283SELECT '{}' AS foo
3284SELECT '{}'::text[] AS foo
3285SELECT '{}'::text AS foo
3286select '{1, 2, 3}'::int4[]
3287select array['a', 'b', '''']::text[]
3288select '{1, 2, 3}'::int4[]
3289select '{1, 2, NULL}'::int4[]
3290select '{192.168.0.1/24}'::inet[]
3291select '{192.168.0.0/24}'::cidr[]
3292select '{10:20:30:40:50:60}'::macaddr[]
3293SELECT musicbandid, clearnameband FROM musicband   ORDER BY clearnameband
3294SELECT idmusicbandnew FROM newmusicband WHERE namemusicbandnew = '" + str(musicname) + "'
3295SELECT %s AS foo", (decimal.Decimal("19.10
3296SELECT %s AS foo", (decimal.Decimal("NaN
3297SELECT %s AS foo", (decimal.Decimal("infinity
3298SELECT %s AS foo", (decimal.Decimal("-infinity
3299SELECT %s AS foo", (float("nan
3300select 'inf'::float
3301SELECT %s AS foo", (float("inf
3302SELECT %s AS foo", (float("-inf
3303select col from array_test where id = 1
3304select col from array_test where id = 2
3305SELECT '{}' AS foo
3306SELECT '{}'::text[] AS foo
3307SELECT '{}'::text AS foo
3308select '{1, 2, 3}'::int4[]
3309select array['a', 'b', '''']::text[]
3310select '{1, 2, 3}'::int4[]
3311select '{1, 2, NULL}'::int4[]
3312select '{192.168.0.1/24}'::inet[]
3313select '{192.168.0.0/24}'::cidr[]
3314select '{10:20:30:40:50:60}'::macaddr[]
3315SELECT * FROM users
3316SELECT %s AS foo", (decimal.Decimal("19.10
3317SELECT %s AS foo", (decimal.Decimal("NaN
3318SELECT %s AS foo", (decimal.Decimal("infinity
3319SELECT %s AS foo", (decimal.Decimal("-infinity
3320SELECT %s AS foo", (float("nan
3321select 'inf'::float
3322SELECT %s AS foo", (float("inf
3323SELECT %s AS foo", (float("-inf
3324select col from array_test where id = 1
3325select col from array_test where id = 2
3326SELECT '{}' AS foo
3327SELECT '{}'::text[] AS foo
3328SELECT '{}'::text AS foo
3329select '{1, 2, 3}'::int4[]
3330select array['a', 'b', '''']::text[]
3331select '{1, 2, 3}'::int4[]
3332select '{1, 2, NULL}'::int4[]
3333select '{192.168.0.1/24}'::inet[]
3334select '{192.168.0.0/24}'::cidr[]
3335select '{10:20:30:40:50:60}'::macaddr[]
3336 UPDATE estado_impresora SET estado = 1,fecha = '"+ str(fechaUTC.fechaConFormato() + " " + fechaUTC.tiempoConFormato()) +"' WHERE idestadoimpresora = 1
3337SELECT max(fecha) FROM boletos;
3338SELECT idplaza FROM plaza WHERE nombre_plaza = '" + plz + "';
3339SELECT max(idboleto) FROM boletos;
3340UPDATE contador_tickets SET conteo = 0 WHERE idconteo = 1
3341SELECT %s AS foo", (decimal.Decimal("19.10
3342SELECT %s AS foo", (decimal.Decimal("NaN
3343SELECT %s AS foo", (decimal.Decimal("infinity
3344SELECT %s AS foo", (decimal.Decimal("-infinity
3345SELECT %s AS foo", (float("nan
3346select 'inf'::float
3347SELECT %s AS foo", (float("inf
3348SELECT %s AS foo", (float("-inf
3349select col from array_test where id = 1
3350select col from array_test where id = 2
3351SELECT '{}' AS foo
3352SELECT '{}'::text[] AS foo
3353SELECT '{}'::text AS foo
3354select '{1, 2, 3}'::int4[]
3355select array['a', 'b', '''']::text[]
3356select '{1, 2, 3}'::int4[]
3357select '{1, 2, NULL}'::int4[]
3358select '{192.168.0.1/24}'::inet[]
3359select '{192.168.0.0/24}'::cidr[]
3360select '{10:20:30:40:50:60}'::macaddr[]
3361SELECT %s AS foo", (decimal.Decimal("19.10
3362SELECT %s AS foo", (decimal.Decimal("NaN
3363SELECT %s AS foo", (decimal.Decimal("infinity
3364SELECT %s AS foo", (decimal.Decimal("-infinity
3365SELECT %s AS foo", (float("nan
3366select 'inf'::float
3367SELECT %s AS foo", (float("inf
3368SELECT %s AS foo", (float("-inf
3369select col from array_test where id = 1
3370select col from array_test where id = 2
3371SELECT '{}' AS foo
3372SELECT '{}'::text[] AS foo
3373SELECT '{}'::text AS foo
3374select '{1, 2, 3}'::int4[]
3375select array['a', 'b', '''']::text[]
3376select '{1, 2, 3}'::int4[]
3377select '{1, 2, NULL}'::int4[]
3378select '{192.168.0.1/24}'::inet[]
3379select '{192.168.0.0/24}'::cidr[]
3380select '{10:20:30:40:50:60}'::macaddr[]
3381SELECT %s AS foo", (decimal.Decimal("19.10
3382SELECT %s AS foo", (decimal.Decimal("NaN
3383SELECT %s AS foo", (decimal.Decimal("infinity
3384SELECT %s AS foo", (decimal.Decimal("-infinity
3385SELECT %s AS foo", (float("nan
3386select 'inf'::float
3387SELECT %s AS foo", (float("inf
3388SELECT %s AS foo", (float("-inf
3389select col from array_test where id = 1
3390select col from array_test where id = 2
3391SELECT '{}' AS foo
3392SELECT '{}'::text[] AS foo
3393SELECT '{}'::text AS foo
3394select '{1, 2, 3}'::int4[]
3395select array['a', 'b', '''']::text[]
3396select '{1, 2, 3}'::int4[]
3397select '{1, 2, NULL}'::int4[]
3398select '{192.168.0.1/24}'::inet[]
3399select '{192.168.0.0/24}'::cidr[]
3400select '{10:20:30:40:50:60}'::macaddr[]
3401show client_encoding
3402show client_encoding
3403SELECT %s AS foo", (decimal.Decimal("19.10
3404SELECT %s AS foo", (decimal.Decimal("NaN
3405SELECT %s AS foo", (decimal.Decimal("infinity
3406SELECT %s AS foo", (decimal.Decimal("-infinity
3407SELECT %s AS foo", (float("nan
3408select 'inf'::float
3409SELECT %s AS foo", (float("inf
3410SELECT %s AS foo", (float("-inf
3411select col from array_test where id = 1
3412select col from array_test where id = 2
3413SELECT '{}' AS foo
3414SELECT '{}'::text[] AS foo
3415SELECT '{}'::text AS foo
3416select '{1, 2, 3}'::int4[]
3417select array['a', 'b', '''']::text[]
3418select '{1, 2, 3}'::int4[]
3419select '{1, 2, NULL}'::int4[]
3420select '{192.168.0.1/24}'::inet[]
3421select '{192.168.0.0/24}'::cidr[]
3422select '{10:20:30:40:50:60}'::macaddr[]
3423SELECT * FROM numbers;
3424SELECT * FROM numbers WHERE lux = True;
3425SELECT * FROM numbers WHERE rooms > 0;
3426SELECT %s AS foo", (decimal.Decimal("19.10
3427SELECT %s AS foo", (decimal.Decimal("NaN
3428SELECT %s AS foo", (decimal.Decimal("infinity
3429SELECT %s AS foo", (decimal.Decimal("-infinity
3430SELECT %s AS foo", (float("nan
3431select 'inf'::float
3432SELECT %s AS foo", (float("inf
3433SELECT %s AS foo", (float("-inf
3434select col from array_test where id = 1
3435select col from array_test where id = 2
3436SELECT '{}' AS foo
3437SELECT '{}'::text[] AS foo
3438SELECT '{}'::text AS foo
3439select '{1, 2, 3}'::int4[]
3440select array['a', 'b', '''']::text[]
3441select '{1, 2, 3}'::int4[]
3442select '{1, 2, NULL}'::int4[]
3443select '{192.168.0.1/24}'::inet[]
3444select '{192.168.0.0/24}'::cidr[]
3445select '{10:20:30:40:50:60}'::macaddr[]
3446SELECT %s AS foo", (decimal.Decimal("19.10
3447SELECT %s AS foo", (decimal.Decimal("NaN
3448SELECT %s AS foo", (decimal.Decimal("infinity
3449SELECT %s AS foo", (decimal.Decimal("-infinity
3450SELECT %s AS foo", (float("nan
3451select 'inf'::float
3452SELECT %s AS foo", (float("inf
3453SELECT %s AS foo", (float("-inf
3454select col from array_test where id = 1
3455select col from array_test where id = 2
3456SELECT '{}' AS foo
3457SELECT '{}'::text[] AS foo
3458SELECT '{}'::text AS foo
3459select '{1, 2, 3}'::int4[]
3460select array['a', 'b', '''']::text[]
3461select '{1, 2, 3}'::int4[]
3462select '{1, 2, NULL}'::int4[]
3463select '{192.168.0.1/24}'::inet[]
3464select '{192.168.0.0/24}'::cidr[]
3465select '{10:20:30:40:50:60}'::macaddr[]
3466SELECT %s AS foo", (decimal.Decimal("19.10
3467SELECT %s AS foo", (decimal.Decimal("NaN
3468SELECT %s AS foo", (decimal.Decimal("infinity
3469SELECT %s AS foo", (decimal.Decimal("-infinity
3470SELECT %s AS foo", (float("nan
3471select 'inf'::float
3472SELECT %s AS foo", (float("inf
3473SELECT %s AS foo", (float("-inf
3474select col from array_test where id = 1
3475select col from array_test where id = 2
3476SELECT '{}' AS foo
3477SELECT '{}'::text[] AS foo
3478SELECT '{}'::text AS foo
3479select '{1, 2, 3}'::int4[]
3480select array['a', 'b', '''']::text[]
3481select '{1, 2, 3}'::int4[]
3482select '{1, 2, NULL}'::int4[]
3483select '{192.168.0.1/24}'::inet[]
3484select '{192.168.0.0/24}'::cidr[]
3485select '{10:20:30:40:50:60}'::macaddr[]
3486SELECT %s AS foo", (decimal.Decimal("19.10
3487SELECT %s AS foo", (decimal.Decimal("NaN
3488SELECT %s AS foo", (decimal.Decimal("infinity
3489SELECT %s AS foo", (decimal.Decimal("-infinity
3490SELECT %s AS foo", (float("nan
3491select 'inf'::float
3492SELECT %s AS foo", (float("inf
3493SELECT %s AS foo", (float("-inf
3494select col from array_test where id = 1
3495select col from array_test where id = 2
3496SELECT '{}' AS foo
3497SELECT '{}'::text[] AS foo
3498SELECT '{}'::text AS foo
3499select '{1, 2, 3}'::int4[]
3500select array['a', 'b', '''']::text[]
3501select '{1, 2, 3}'::int4[]
3502select '{1, 2, NULL}'::int4[]
3503select '{192.168.0.1/24}'::inet[]
3504select '{192.168.0.0/24}'::cidr[]
3505select '{10:20:30:40:50:60}'::macaddr[]
3506SELECT %s AS foo", (decimal.Decimal("19.10
3507SELECT %s AS foo", (decimal.Decimal("NaN
3508SELECT %s AS foo", (decimal.Decimal("infinity
3509SELECT %s AS foo", (decimal.Decimal("-infinity
3510SELECT %s AS foo", (float("nan
3511select 'inf'::float
3512SELECT %s AS foo", (float("inf
3513SELECT %s AS foo", (float("-inf
3514select col from array_test where id = 1
3515select col from array_test where id = 2
3516SELECT '{}' AS foo
3517SELECT '{}'::text[] AS foo
3518SELECT '{}'::text AS foo
3519select '{1, 2, 3}'::int4[]
3520select array['a', 'b', '''']::text[]
3521select '{1, 2, 3}'::int4[]
3522select '{1, 2, NULL}'::int4[]
3523select '{192.168.0.1/24}'::inet[]
3524select '{192.168.0.0/24}'::cidr[]
3525select '{10:20:30:40:50:60}'::macaddr[]
3526SELECT %s AS foo", (decimal.Decimal("19.10
3527SELECT %s AS foo", (decimal.Decimal("NaN
3528SELECT %s AS foo", (decimal.Decimal("infinity
3529SELECT %s AS foo", (decimal.Decimal("-infinity
3530SELECT %s AS foo", (float("nan
3531select 'inf'::float
3532SELECT %s AS foo", (float("inf
3533SELECT %s AS foo", (float("-inf
3534select col from array_test where id = 1
3535select col from array_test where id = 2
3536SELECT '{}' AS foo
3537SELECT '{}'::text[] AS foo
3538SELECT '{}'::text AS foo
3539select '{1, 2, 3}'::int4[]
3540select array['a', 'b', '''']::text[]
3541select '{1, 2, 3}'::int4[]
3542select '{1, 2, NULL}'::int4[]
3543select '{192.168.0.1/24}'::inet[]
3544select '{192.168.0.0/24}'::cidr[]
3545select '{10:20:30:40:50:60}'::macaddr[]
3546SELECT %s AS foo", (decimal.Decimal("19.10
3547SELECT %s AS foo", (decimal.Decimal("NaN
3548SELECT %s AS foo", (decimal.Decimal("infinity
3549SELECT %s AS foo", (decimal.Decimal("-infinity
3550SELECT %s AS foo", (float("nan
3551select 'inf'::float
3552SELECT %s AS foo", (float("inf
3553SELECT %s AS foo", (float("-inf
3554select col from array_test where id = 1
3555select col from array_test where id = 2
3556SELECT '{}' AS foo
3557SELECT '{}'::text[] AS foo
3558SELECT '{}'::text AS foo
3559select '{1, 2, 3}'::int4[]
3560select array['a', 'b', '''']::text[]
3561select '{1, 2, 3}'::int4[]
3562select '{1, 2, NULL}'::int4[]
3563select '{192.168.0.1/24}'::inet[]
3564select '{192.168.0.0/24}'::cidr[]
3565select '{10:20:30:40:50:60}'::macaddr[]
3566SELECT %s AS foo", (decimal.Decimal("19.10
3567SELECT %s AS foo", (decimal.Decimal("NaN
3568SELECT %s AS foo", (decimal.Decimal("infinity
3569SELECT %s AS foo", (decimal.Decimal("-infinity
3570SELECT %s AS foo", (float("nan
3571select 'inf'::float
3572SELECT %s AS foo", (float("inf
3573SELECT %s AS foo", (float("-inf
3574select col from array_test where id = 1
3575select col from array_test where id = 2
3576SELECT '{}' AS foo
3577SELECT '{}'::text[] AS foo
3578SELECT '{}'::text AS foo
3579select '{1, 2, 3}'::int4[]
3580select array['a', 'b', '''']::text[]
3581select '{1, 2, 3}'::int4[]
3582select '{1, 2, NULL}'::int4[]
3583select '{192.168.0.1/24}'::inet[]
3584select '{192.168.0.0/24}'::cidr[]
3585select '{10:20:30:40:50:60}'::macaddr[]
3586SELECT %s AS foo", (decimal.Decimal("19.10
3587SELECT %s AS foo", (decimal.Decimal("NaN
3588SELECT %s AS foo", (decimal.Decimal("infinity
3589SELECT %s AS foo", (decimal.Decimal("-infinity
3590SELECT %s AS foo", (float("nan
3591select 'inf'::float
3592SELECT %s AS foo", (float("inf
3593SELECT %s AS foo", (float("-inf
3594select col from array_test where id = 1
3595select col from array_test where id = 2
3596SELECT '{}' AS foo
3597SELECT '{}'::text[] AS foo
3598SELECT '{}'::text AS foo
3599select '{1, 2, 3}'::int4[]
3600select array['a', 'b', '''']::text[]
3601select '{1, 2, 3}'::int4[]
3602select '{1, 2, NULL}'::int4[]
3603select '{192.168.0.1/24}'::inet[]
3604select '{192.168.0.0/24}'::cidr[]
3605select '{10:20:30:40:50:60}'::macaddr[]
3606SELECT %s AS foo", (decimal.Decimal("19.10
3607SELECT %s AS foo", (decimal.Decimal("NaN
3608SELECT %s AS foo", (decimal.Decimal("infinity
3609SELECT %s AS foo", (decimal.Decimal("-infinity
3610SELECT %s AS foo", (float("nan
3611select 'inf'::float
3612SELECT %s AS foo", (float("inf
3613SELECT %s AS foo", (float("-inf
3614select col from array_test where id = 1
3615select col from array_test where id = 2
3616SELECT '{}' AS foo
3617SELECT '{}'::text[] AS foo
3618SELECT '{}'::text AS foo
3619select '{1, 2, 3}'::int4[]
3620select array['a', 'b', '''']::text[]
3621select '{1, 2, 3}'::int4[]
3622select '{1, 2, NULL}'::int4[]
3623select '{192.168.0.1/24}'::inet[]
3624select '{192.168.0.0/24}'::cidr[]
3625select '{10:20:30:40:50:60}'::macaddr[]
3626\dt"+"\n
3627SELECT email FROM 한양인주소록
3628SELECT * FROM pg_tables WHERE schemaname='public';
3629SELECT %s AS foo", (decimal.Decimal("19.10
3630SELECT %s AS foo", (decimal.Decimal("NaN
3631SELECT %s AS foo", (decimal.Decimal("infinity
3632SELECT %s AS foo", (decimal.Decimal("-infinity
3633SELECT %s AS foo", (float("nan
3634select 'inf'::float
3635SELECT %s AS foo", (float("inf
3636SELECT %s AS foo", (float("-inf
3637select col from array_test where id = 1
3638select col from array_test where id = 2
3639SELECT '{}' AS foo
3640SELECT '{}'::text[] AS foo
3641SELECT '{}'::text AS foo
3642select '{1, 2, 3}'::int4[]
3643select array['a', 'b', '''']::text[]
3644select '{1, 2, 3}'::int4[]
3645select '{1, 2, NULL}'::int4[]
3646select '{192.168.0.1/24}'::inet[]
3647select '{192.168.0.0/24}'::cidr[]
3648select '{10:20:30:40:50:60}'::macaddr[]
3649SELECT %s AS foo", (decimal.Decimal("19.10
3650SELECT %s AS foo", (decimal.Decimal("NaN
3651SELECT %s AS foo", (decimal.Decimal("infinity
3652SELECT %s AS foo", (decimal.Decimal("-infinity
3653SELECT %s AS foo", (float("nan
3654select 'inf'::float
3655SELECT %s AS foo", (float("inf
3656SELECT %s AS foo", (float("-inf
3657create table array_test (id integer, col timestamp without time zone[])
3658select col from array_test where id = 1
3659select col from array_test where id = 2
3660SELECT '{}' AS foo
3661SELECT '{}'::text[] AS foo
3662SELECT '{}'::text AS foo
3663select '{1,2,3}'::int4[]
3664select array['a','b','''']::text[]
3665select '{1,2,3}'::int4[]
3666select '{1,2,NULL}'::int4[]
3667SELECT dream From user_dreams
3668SELECT dream From user_dreams
3669SELECT %s AS foo", (decimal.Decimal("19.10
3670SELECT %s AS foo", (decimal.Decimal("NaN
3671SELECT %s AS foo", (decimal.Decimal("infinity
3672SELECT %s AS foo", (decimal.Decimal("-infinity
3673SELECT %s AS foo", (float("nan
3674select 'inf'::float
3675SELECT %s AS foo", (float("inf
3676SELECT %s AS foo", (float("-inf
3677select col from array_test where id = 1
3678select col from array_test where id = 2
3679SELECT '{}' AS foo
3680SELECT '{}'::text[] AS foo
3681SELECT '{}'::text AS foo
3682select '{1, 2, 3}'::int4[]
3683select array['a', 'b', '''']::text[]
3684select '{1, 2, 3}'::int4[]
3685select '{1, 2, NULL}'::int4[]
3686select '{192.168.0.1/24}'::inet[]
3687select '{192.168.0.0/24}'::cidr[]
3688select '{10:20:30:40:50:60}'::macaddr[]
3689SELECT %s AS foo", (decimal.Decimal("19.10
3690SELECT %s AS foo", (decimal.Decimal("NaN
3691SELECT %s AS foo", (decimal.Decimal("infinity
3692SELECT %s AS foo", (decimal.Decimal("-infinity
3693SELECT %s AS foo", (float("nan
3694select 'inf'::float
3695SELECT %s AS foo", (float("inf
3696SELECT %s AS foo", (float("-inf
3697select col from array_test where id = 1
3698select col from array_test where id = 2
3699SELECT '{}' AS foo
3700SELECT '{}'::text[] AS foo
3701SELECT '{}'::text AS foo
3702select '{1, 2, 3}'::int4[]
3703select array['a', 'b', '''']::text[]
3704select '{1, 2, 3}'::int4[]
3705select '{1, 2, NULL}'::int4[]
3706select '{192.168.0.1/24}'::inet[]
3707select '{192.168.0.0/24}'::cidr[]
3708select '{10:20:30:40:50:60}'::macaddr[]
3709SELECT %s AS foo", (decimal.Decimal("19.10
3710SELECT %s AS foo", (decimal.Decimal("NaN
3711SELECT %s AS foo", (decimal.Decimal("infinity
3712SELECT %s AS foo", (decimal.Decimal("-infinity
3713SELECT %s AS foo", (float("nan
3714select 'inf'::float
3715SELECT %s AS foo", (float("inf
3716SELECT %s AS foo", (float("-inf
3717select col from array_test where id = 1
3718select col from array_test where id = 2
3719SELECT '{}' AS foo
3720SELECT '{}'::text[] AS foo
3721SELECT '{}'::text AS foo
3722select '{1, 2, 3}'::int4[]
3723select array['a', 'b', '''']::text[]
3724select '{1, 2, 3}'::int4[]
3725select '{1, 2, NULL}'::int4[]
3726select '{192.168.0.1/24}'::inet[]
3727select '{192.168.0.0/24}'::cidr[]
3728select '{10:20:30:40:50:60}'::macaddr[]
3729SELECT %s AS foo", (decimal.Decimal("19.10
3730SELECT %s AS foo", (decimal.Decimal("NaN
3731SELECT %s AS foo", (decimal.Decimal("infinity
3732SELECT %s AS foo", (decimal.Decimal("-infinity
3733SELECT %s AS foo", (float("nan
3734select 'inf'::float
3735SELECT %s AS foo", (float("inf
3736SELECT %s AS foo", (float("-inf
3737select col from array_test where id = 1
3738select col from array_test where id = 2
3739SELECT '{}' AS foo
3740SELECT '{}'::text[] AS foo
3741SELECT '{}'::text AS foo
3742select '{1, 2, 3}'::int4[]
3743select array['a', 'b', '''']::text[]
3744select '{1, 2, 3}'::int4[]
3745select '{1, 2, NULL}'::int4[]
3746select '{192.168.0.1/24}'::inet[]
3747select '{192.168.0.0/24}'::cidr[]
3748select '{10:20:30:40:50:60}'::macaddr[]
3749SELECT %s AS foo", (decimal.Decimal("19.10
3750SELECT %s AS foo", (decimal.Decimal("NaN
3751SELECT %s AS foo", (decimal.Decimal("infinity
3752SELECT %s AS foo", (decimal.Decimal("-infinity
3753SELECT %s AS foo", (float("nan
3754select 'inf'::float
3755SELECT %s AS foo", (float("inf
3756SELECT %s AS foo", (float("-inf
3757select col from array_test where id = 1
3758select col from array_test where id = 2
3759SELECT '{}' AS foo
3760SELECT '{}'::text[] AS foo
3761SELECT '{}'::text AS foo
3762select '{1, 2, 3}'::int4[]
3763select array['a', 'b', '''']::text[]
3764select '{1, 2, 3}'::int4[]
3765select '{1, 2, NULL}'::int4[]
3766select '{192.168.0.1/24}'::inet[]
3767select '{192.168.0.0/24}'::cidr[]
3768select '{10:20:30:40:50:60}'::macaddr[]
3769SELECT %s AS foo", (decimal.Decimal("19.10
3770SELECT %s AS foo", (decimal.Decimal("NaN
3771SELECT %s AS foo", (decimal.Decimal("infinity
3772SELECT %s AS foo", (decimal.Decimal("-infinity
3773SELECT %s AS foo", (float("nan
3774select 'inf'::float
3775SELECT %s AS foo", (float("inf
3776SELECT %s AS foo", (float("-inf
3777select col from array_test where id = 1
3778select col from array_test where id = 2
3779SELECT '{}' AS foo
3780SELECT '{}'::text[] AS foo
3781SELECT '{}'::text AS foo
3782select '{1, 2, 3}'::int4[]
3783select array['a', 'b', '''']::text[]
3784select '{1, 2, 3}'::int4[]
3785select '{1, 2, NULL}'::int4[]
3786select '{192.168.0.1/24}'::inet[]
3787select '{192.168.0.0/24}'::cidr[]
3788select '{10:20:30:40:50:60}'::macaddr[]
3789SELECT %s AS foo", (decimal.Decimal("19.10
3790SELECT %s AS foo", (decimal.Decimal("NaN
3791SELECT %s AS foo", (decimal.Decimal("infinity
3792SELECT %s AS foo", (decimal.Decimal("-infinity
3793SELECT %s AS foo", (float("nan
3794select 'inf'::float
3795SELECT %s AS foo", (float("inf
3796SELECT %s AS foo", (float("-inf
3797select col from array_test where id = 1
3798select col from array_test where id = 2
3799SELECT '{}' AS foo
3800SELECT '{}'::text[] AS foo
3801SELECT '{}'::text AS foo
3802select '{1, 2, 3}'::int4[]
3803select array['a', 'b', '''']::text[]
3804select '{1, 2, 3}'::int4[]
3805select '{1, 2, NULL}'::int4[]
3806select '{192.168.0.1/24}'::inet[]
3807select '{192.168.0.0/24}'::cidr[]
3808select '{10:20:30:40:50:60}'::macaddr[]
3809SELECT %s AS foo", (decimal.Decimal("19.10
3810SELECT %s AS foo", (decimal.Decimal("NaN
3811SELECT %s AS foo", (decimal.Decimal("infinity
3812SELECT %s AS foo", (decimal.Decimal("-infinity
3813SELECT %s AS foo", (float("nan
3814select 'inf'::float
3815SELECT %s AS foo", (float("inf
3816SELECT %s AS foo", (float("-inf
3817select col from array_test where id = 1
3818select col from array_test where id = 2
3819SELECT '{}' AS foo
3820SELECT '{}'::text[] AS foo
3821SELECT '{}'::text AS foo
3822select '{1, 2, 3}'::int4[]
3823select array['a', 'b', '''']::text[]
3824select '{1, 2, 3}'::int4[]
3825select '{1, 2, NULL}'::int4[]
3826select '{192.168.0.1/24}'::inet[]
3827select '{192.168.0.0/24}'::cidr[]
3828select '{10:20:30:40:50:60}'::macaddr[]
3829SELECT %s AS foo", (decimal.Decimal("19.10
3830SELECT %s AS foo", (decimal.Decimal("NaN
3831SELECT %s AS foo", (decimal.Decimal("infinity
3832SELECT %s AS foo", (decimal.Decimal("-infinity
3833SELECT %s AS foo", (float("nan
3834select 'inf'::float
3835SELECT %s AS foo", (float("inf
3836SELECT %s AS foo", (float("-inf
3837select col from array_test where id = 1
3838select col from array_test where id = 2
3839SELECT '{}' AS foo
3840SELECT '{}'::text[] AS foo
3841SELECT '{}'::text AS foo
3842select '{1, 2, 3}'::int4[]
3843select array['a', 'b', '''']::text[]
3844select '{1, 2, 3}'::int4[]
3845select '{1, 2, NULL}'::int4[]
3846select '{192.168.0.1/24}'::inet[]
3847select '{192.168.0.0/24}'::cidr[]
3848select '{10:20:30:40:50:60}'::macaddr[]
3849SELECT %s AS foo", (decimal.Decimal("19.10
3850SELECT %s AS foo", (decimal.Decimal("NaN
3851SELECT %s AS foo", (decimal.Decimal("infinity
3852SELECT %s AS foo", (decimal.Decimal("-infinity
3853SELECT %s AS foo", (float("nan
3854select 'inf'::float
3855SELECT %s AS foo", (float("inf
3856SELECT %s AS foo", (float("-inf
3857select col from array_test where id = 1
3858select col from array_test where id = 2
3859SELECT '{}' AS foo
3860SELECT '{}'::text[] AS foo
3861SELECT '{}'::text AS foo
3862select '{1, 2, 3}'::int4[]
3863select array['a', 'b', '''']::text[]
3864select '{1, 2, 3}'::int4[]
3865select '{1, 2, NULL}'::int4[]
3866select '{192.168.0.1/24}'::inet[]
3867select '{192.168.0.0/24}'::cidr[]
3868select '{10:20:30:40:50:60}'::macaddr[]
3869SELECT %s AS foo", (decimal.Decimal("19.10
3870SELECT %s AS foo", (decimal.Decimal("NaN
3871SELECT %s AS foo", (decimal.Decimal("infinity
3872SELECT %s AS foo", (decimal.Decimal("-infinity
3873SELECT %s AS foo", (float("nan
3874select 'inf'::float
3875SELECT %s AS foo", (float("inf
3876SELECT %s AS foo", (float("-inf
3877select col from array_test where id = 1
3878select col from array_test where id = 2
3879SELECT '{}' AS foo
3880SELECT '{}'::text[] AS foo
3881SELECT '{}'::text AS foo
3882select '{1, 2, 3}'::int4[]
3883select array['a', 'b', '''']::text[]
3884select '{1, 2, 3}'::int4[]
3885select '{1, 2, NULL}'::int4[]
3886select '{192.168.0.1/24}'::inet[]
3887select '{192.168.0.0/24}'::cidr[]
3888select '{10:20:30:40:50:60}'::macaddr[]
3889SELECT * FROM humans ORDER BY human_id DESC
3890SELECT * FROM simcards ORDER BY id DESC
3891SELECT %s AS foo", (decimal.Decimal("19.10
3892SELECT %s AS foo", (decimal.Decimal("NaN
3893SELECT %s AS foo", (decimal.Decimal("infinity
3894SELECT %s AS foo", (decimal.Decimal("-infinity
3895SELECT %s AS foo", (float("nan
3896select 'inf'::float
3897SELECT %s AS foo", (float("inf
3898SELECT %s AS foo", (float("-inf
3899create table array_test (id integer, col timestamp without time zone[])
3900select col from array_test where id = 1
3901select col from array_test where id = 2
3902SELECT '{}' AS foo
3903SELECT '{}'::text[] AS foo
3904SELECT '{}'::text AS foo
3905select '{1,2,3}'::int4[]
3906select array['a','b','''']::text[]
3907select '{1,2,3}'::int4[]
3908select '{1,2,NULL}'::int4[]
3909SELECT %s AS foo", (decimal.Decimal("19.10
3910SELECT %s AS foo", (decimal.Decimal("NaN
3911SELECT %s AS foo", (decimal.Decimal("infinity
3912SELECT %s AS foo", (decimal.Decimal("-infinity
3913SELECT %s AS foo", (float("nan
3914select 'inf'::float
3915SELECT %s AS foo", (float("inf
3916SELECT %s AS foo", (float("-inf
3917select col from array_test where id = 1
3918select col from array_test where id = 2
3919SELECT '{}' AS foo
3920SELECT '{}'::text[] AS foo
3921SELECT '{}'::text AS foo
3922select '{1, 2, 3}'::int4[]
3923select array['a', 'b', '''']::text[]
3924select '{1, 2, 3}'::int4[]
3925select '{1, 2, NULL}'::int4[]
3926select '{192.168.0.1/24}'::inet[]
3927select '{192.168.0.0/24}'::cidr[]
3928select '{10:20:30:40:50:60}'::macaddr[]
3929SELECT %s AS foo", (decimal.Decimal("19.10
3930SELECT %s AS foo", (decimal.Decimal("NaN
3931SELECT %s AS foo", (decimal.Decimal("infinity
3932SELECT %s AS foo", (decimal.Decimal("-infinity
3933SELECT %s AS foo", (float("nan
3934select 'inf'::float
3935SELECT %s AS foo", (float("inf
3936SELECT %s AS foo", (float("-inf
3937select col from array_test where id = 1
3938select col from array_test where id = 2
3939SELECT '{}' AS foo
3940SELECT '{}'::text[] AS foo
3941SELECT '{}'::text AS foo
3942select '{1, 2, 3}'::int4[]
3943select array['a', 'b', '''']::text[]
3944select '{1, 2, 3}'::int4[]
3945select '{1, 2, NULL}'::int4[]
3946select '{192.168.0.1/24}'::inet[]
3947select '{192.168.0.0/24}'::cidr[]
3948select '{10:20:30:40:50:60}'::macaddr[]
3949SELECT %s AS foo", (decimal.Decimal("19.10
3950SELECT %s AS foo", (decimal.Decimal("NaN
3951SELECT %s AS foo", (decimal.Decimal("infinity
3952SELECT %s AS foo", (decimal.Decimal("-infinity
3953SELECT %s AS foo", (float("nan
3954select 'inf'::float
3955SELECT %s AS foo", (float("inf
3956SELECT %s AS foo", (float("-inf
3957select col from array_test where id = 1
3958select col from array_test where id = 2
3959SELECT '{}' AS foo
3960SELECT '{}'::text[] AS foo
3961SELECT '{}'::text AS foo
3962select '{1, 2, 3}'::int4[]
3963select array['a', 'b', '''']::text[]
3964select '{1, 2, 3}'::int4[]
3965select '{1, 2, NULL}'::int4[]
3966select '{192.168.0.1/24}'::inet[]
3967select '{192.168.0.0/24}'::cidr[]
3968select '{10:20:30:40:50:60}'::macaddr[]
3969SELECT %s AS foo", (decimal.Decimal("19.10
3970SELECT %s AS foo", (decimal.Decimal("NaN
3971SELECT %s AS foo", (decimal.Decimal("infinity
3972SELECT %s AS foo", (decimal.Decimal("-infinity
3973SELECT %s AS foo", (float("nan
3974select 'inf'::float
3975SELECT %s AS foo", (float("inf
3976SELECT %s AS foo", (float("-inf
3977select col from array_test where id = 1
3978select col from array_test where id = 2
3979SELECT '{}' AS foo
3980SELECT '{}'::text[] AS foo
3981SELECT '{}'::text AS foo
3982select '{1, 2, 3}'::int4[]
3983select array['a', 'b', '''']::text[]
3984select '{1, 2, 3}'::int4[]
3985select '{1, 2, NULL}'::int4[]
3986select '{192.168.0.1/24}'::inet[]
3987select '{192.168.0.0/24}'::cidr[]
3988select '{10:20:30:40:50:60}'::macaddr[]
3989SELECT %s AS foo", (decimal.Decimal("19.10
3990SELECT %s AS foo", (decimal.Decimal("NaN
3991SELECT %s AS foo", (decimal.Decimal("infinity
3992SELECT %s AS foo", (decimal.Decimal("-infinity
3993SELECT %s AS foo", (float("nan
3994select 'inf'::float
3995SELECT %s AS foo", (float("inf
3996SELECT %s AS foo", (float("-inf
3997select col from array_test where id = 1
3998select col from array_test where id = 2
3999SELECT '{}' AS foo
4000SELECT '{}'::text[] AS foo
4001SELECT '{}'::text AS foo
4002select '{1, 2, 3}'::int4[]
4003select array['a', 'b', '''']::text[]
4004select '{1, 2, 3}'::int4[]
4005select '{1, 2, NULL}'::int4[]
4006select '{192.168.0.1/24}'::inet[]
4007select '{192.168.0.0/24}'::cidr[]
4008select '{10:20:30:40:50:60}'::macaddr[]
4009SELECT products_brand as name,'Airtel' as operator,operation_type as type,_from as from,_to as to FROM airtel_lookup
4010SELECT %s AS foo", (decimal.Decimal("19.10
4011SELECT %s AS foo", (decimal.Decimal("NaN
4012SELECT %s AS foo", (decimal.Decimal("infinity
4013SELECT %s AS foo", (decimal.Decimal("-infinity
4014SELECT %s AS foo", (float("nan
4015select 'inf'::float
4016SELECT %s AS foo", (float("inf
4017SELECT %s AS foo", (float("-inf
4018select col from array_test where id = 1
4019select col from array_test where id = 2
4020SELECT '{}' AS foo
4021SELECT '{}'::text[] AS foo
4022SELECT '{}'::text AS foo
4023select '{1, 2, 3}'::int4[]
4024select array['a', 'b', '''']::text[]
4025select '{1, 2, 3}'::int4[]
4026select '{1, 2, NULL}'::int4[]
4027select '{192.168.0.1/24}'::inet[]
4028select '{192.168.0.0/24}'::cidr[]
4029select '{10:20:30:40:50:60}'::macaddr[]
4030SELECT %s AS foo", (decimal.Decimal("19.10
4031SELECT %s AS foo", (decimal.Decimal("NaN
4032SELECT %s AS foo", (decimal.Decimal("infinity
4033SELECT %s AS foo", (decimal.Decimal("-infinity
4034SELECT %s AS foo", (float("nan
4035select 'inf'::float
4036SELECT %s AS foo", (float("inf
4037SELECT %s AS foo", (float("-inf
4038select col from array_test where id = 1
4039select col from array_test where id = 2
4040SELECT '{}' AS foo
4041SELECT '{}'::text[] AS foo
4042SELECT '{}'::text AS foo
4043select '{1, 2, 3}'::int4[]
4044select array['a', 'b', '''']::text[]
4045select '{1, 2, 3}'::int4[]
4046select '{1, 2, NULL}'::int4[]
4047select '{192.168.0.1/24}'::inet[]
4048select '{192.168.0.0/24}'::cidr[]
4049select '{10:20:30:40:50:60}'::macaddr[]
4050SELECT %s AS foo", (decimal.Decimal("19.10
4051SELECT %s AS foo", (decimal.Decimal("NaN
4052SELECT %s AS foo", (decimal.Decimal("infinity
4053SELECT %s AS foo", (decimal.Decimal("-infinity
4054SELECT %s AS foo", (float("nan
4055select 'inf'::float
4056SELECT %s AS foo", (float("inf
4057SELECT %s AS foo", (float("-inf
4058select col from array_test where id = 1
4059select col from array_test where id = 2
4060SELECT '{}' AS foo
4061SELECT '{}'::text[] AS foo
4062SELECT '{}'::text AS foo
4063select '{1, 2, 3}'::int4[]
4064select array['a', 'b', '''']::text[]
4065select '{1, 2, 3}'::int4[]
4066select '{1, 2, NULL}'::int4[]
4067select '{192.168.0.1/24}'::inet[]
4068select '{192.168.0.0/24}'::cidr[]
4069select '{10:20:30:40:50:60}'::macaddr[]
4070SELECT %s AS foo", (decimal.Decimal("19.10
4071SELECT %s AS foo", (decimal.Decimal("NaN
4072SELECT %s AS foo", (decimal.Decimal("infinity
4073SELECT %s AS foo", (decimal.Decimal("-infinity
4074SELECT %s AS foo", (float("nan
4075select 'inf'::float
4076SELECT %s AS foo", (float("inf
4077SELECT %s AS foo", (float("-inf
4078select col from array_test where id = 1
4079select col from array_test where id = 2
4080SELECT '{}' AS foo
4081SELECT '{}'::text[] AS foo
4082SELECT '{}'::text AS foo
4083select '{1, 2, 3}'::int4[]
4084select array['a', 'b', '''']::text[]
4085select '{1, 2, 3}'::int4[]
4086select '{1, 2, NULL}'::int4[]
4087select '{192.168.0.1/24}'::inet[]
4088select '{192.168.0.0/24}'::cidr[]
4089select '{10:20:30:40:50:60}'::macaddr[]
4090SELECT %s AS foo", (decimal.Decimal("19.10
4091SELECT %s AS foo", (decimal.Decimal("NaN
4092SELECT %s AS foo", (decimal.Decimal("infinity
4093SELECT %s AS foo", (decimal.Decimal("-infinity
4094SELECT %s AS foo", (float("nan
4095select 'inf'::float
4096SELECT %s AS foo", (float("inf
4097SELECT %s AS foo", (float("-inf
4098create table array_test (id integer, col timestamp without time zone[])
4099select col from array_test where id = 1
4100select col from array_test where id = 2
4101SELECT '{}' AS foo
4102SELECT '{}'::text[] AS foo
4103SELECT '{}'::text AS foo
4104select '{1,2,3}'::int4[]
4105select array['a','b','''']::text[]
4106select '{1,2,3}'::int4[]
4107select '{1,2,NULL}'::int4[]
4108SELECT %s AS foo", (decimal.Decimal("19.10
4109SELECT %s AS foo", (decimal.Decimal("NaN
4110SELECT %s AS foo", (decimal.Decimal("infinity
4111SELECT %s AS foo", (decimal.Decimal("-infinity
4112SELECT %s AS foo", (float("nan
4113select 'inf'::float
4114SELECT %s AS foo", (float("inf
4115SELECT %s AS foo", (float("-inf
4116select col from array_test where id = 1
4117select col from array_test where id = 2
4118SELECT '{}' AS foo
4119SELECT '{}'::text[] AS foo
4120SELECT '{}'::text AS foo
4121select '{1, 2, 3}'::int4[]
4122select array['a', 'b', '''']::text[]
4123select '{1, 2, 3}'::int4[]
4124select '{1, 2, NULL}'::int4[]
4125select '{192.168.0.1/24}'::inet[]
4126select '{192.168.0.0/24}'::cidr[]
4127select '{10:20:30:40:50:60}'::macaddr[]
4128SELECT %s AS foo", (decimal.Decimal("19.10
4129SELECT %s AS foo", (decimal.Decimal("NaN
4130SELECT %s AS foo", (decimal.Decimal("infinity
4131SELECT %s AS foo", (decimal.Decimal("-infinity
4132SELECT %s AS foo", (float("nan
4133select 'inf'::float
4134SELECT %s AS foo", (float("inf
4135SELECT %s AS foo", (float("-inf
4136select col from array_test where id = 1
4137select col from array_test where id = 2
4138SELECT '{}' AS foo
4139SELECT '{}'::text[] AS foo
4140SELECT '{}'::text AS foo
4141select '{1, 2, 3}'::int4[]
4142select array['a', 'b', '''']::text[]
4143select '{1, 2, 3}'::int4[]
4144select '{1, 2, NULL}'::int4[]
4145select '{192.168.0.1/24}'::inet[]
4146select '{192.168.0.0/24}'::cidr[]
4147select '{10:20:30:40:50:60}'::macaddr[]
4148SELECT %s AS foo", (decimal.Decimal("19.10
4149SELECT %s AS foo", (decimal.Decimal("NaN
4150SELECT %s AS foo", (decimal.Decimal("infinity
4151SELECT %s AS foo", (decimal.Decimal("-infinity
4152SELECT %s AS foo", (float("nan
4153select 'inf'::float
4154SELECT %s AS foo", (float("inf
4155SELECT %s AS foo", (float("-inf
4156select col from array_test where id = 1
4157select col from array_test where id = 2
4158SELECT '{}' AS foo
4159SELECT '{}'::text[] AS foo
4160SELECT '{}'::text AS foo
4161select '{1, 2, 3}'::int4[]
4162select array['a', 'b', '''']::text[]
4163select '{1, 2, 3}'::int4[]
4164select '{1, 2, NULL}'::int4[]
4165select '{192.168.0.1/24}'::inet[]
4166select '{192.168.0.0/24}'::cidr[]
4167select '{10:20:30:40:50:60}'::macaddr[]
4168SELECT %s AS foo", (decimal.Decimal("19.10
4169SELECT %s AS foo", (decimal.Decimal("NaN
4170SELECT %s AS foo", (decimal.Decimal("infinity
4171SELECT %s AS foo", (decimal.Decimal("-infinity
4172SELECT %s AS foo", (float("nan
4173select 'inf'::float
4174SELECT %s AS foo", (float("inf
4175SELECT %s AS foo", (float("-inf
4176select col from array_test where id = 1
4177select col from array_test where id = 2
4178SELECT '{}' AS foo
4179SELECT '{}'::text[] AS foo
4180SELECT '{}'::text AS foo
4181select '{1, 2, 3}'::int4[]
4182select array['a', 'b', '''']::text[]
4183select '{1, 2, 3}'::int4[]
4184select '{1, 2, NULL}'::int4[]
4185select '{192.168.0.1/24}'::inet[]
4186select '{192.168.0.0/24}'::cidr[]
4187select '{10:20:30:40:50:60}'::macaddr[]
4188DROP TABLE table1
4189DROP TABLE table2
4190INSERT INTO table1 VALUES (1, 'hello')
4191CREATE TABLE table2 (id int PRIMARY KEY)
4192DROP TABLE table1
4193DROP TABLE table2
4194LOCK table1 IN ACCESS EXCLUSIVE MODE
4195LOCK table2 IN ACCESS EXCLUSIVE MODE
4196LOCK table2 IN ACCESS EXCLUSIVE MODE
4197LOCK table1 IN ACCESS EXCLUSIVE MODE
4198SELECT name FROM table1 WHERE id = 1
4199UPDATE table1 SET name='task1' WHERE id = 1
4200UPDATE table1 SET name='task2' WHERE id = 1
4201SELECT %s AS foo", (decimal.Decimal("19.10
4202SELECT %s AS foo", (decimal.Decimal("NaN
4203SELECT %s AS foo", (decimal.Decimal("infinity
4204SELECT %s AS foo", (decimal.Decimal("-infinity
4205SELECT %s AS foo", (float("nan
4206select 'inf'::float
4207SELECT %s AS foo", (float("inf
4208SELECT %s AS foo", (float("-inf
4209select col from array_test where id = 1
4210select col from array_test where id = 2
4211SELECT '{}' AS foo
4212SELECT '{}'::text[] AS foo
4213SELECT '{}'::text AS foo
4214select '{1, 2, 3}'::int4[]
4215select array['a', 'b', '''']::text[]
4216select '{1, 2, 3}'::int4[]
4217select '{1, 2, NULL}'::int4[]
4218select '{192.168.0.1/24}'::inet[]
4219select '{192.168.0.0/24}'::cidr[]
4220select '{10:20:30:40:50:60}'::macaddr[]
4221CREATE TABLE IF NOT EXISTS payPds (id SERIAL PRIMARY KEY, date VARCHAR(255), totalSavings INTEGER, diff INTEGER, diffGoal INTEGER, account VARCHAR(255))
4222SELECT * FROM payPds
4223SELECT COUNT(*) FROM payPds
4224SELECT id FROM payPds
4225CREATE TABLE IF NOT EXISTS users (id SERIAL PRIMARY KEY, fname VARCHAR(255), lname VARCHAR(255), email VARCHAR(255), hashpass VARCHAR(255))
4226SELECT * FROM users
4227CREATE TABLE IF NOT EXISTS adminList(uid SERIAL PRIMARY KEY, fname VARCHAR(255), lname VARCHAR(255), username VARCHAR(255), password VARCHAR(255))
4228SELECT * FROM adminList
4229CREATE TABLE IF NOT EXISTS TopicList(tid SERIAL PRIMARY KEY, topic VARCHAR(1000))
4230CREATE TABLE IF NOT EXISTS QuestionList(qid SERIAL PRIMARY KEY, question VARCHAR(1000), topicID INT, choiceA VARCHAR(1000), choiceB VARCHAR(1000), choiceC VARCHAR(1000), choiceD VARCHAR(1000))
4231SELECT * FROM TopicList
4232drop table if exists Rel;
4233create table Rel as (select id, v0, CASE WHEN random() < p THEN 1 ELSE 0 END as p from smokes);
4234select count(*) from Rel where p = 1
4235drop table if exists Rel;
4236create table Rel as (select id, v0, CASE WHEN random() < p THEN 1 ELSE 0 END as p from smokes);
4237select count(*) from Rel where p = 1
4238drop table if exists Rel;
4239create table Rel as (select id, v0, CASE WHEN random() < p THEN 1 ELSE 0 END as p from smokes);
4240select count(*) from Rel where p = 1
4241drop table if exists Rel;
4242create table Rel as (select id, v0, CASE WHEN random() < p THEN 1 ELSE 0 END as p from smokes);
4243select count(*) from Rel where p = 1
4244drop table if exists Rel;
4245create table Rel as (select id, v0, CASE WHEN random() < p THEN 1 ELSE 0 END as p from smokes);
4246select count(*) from Rel where p = 1
4247""SELECT * FROM applicants""
4248TRUNCATE article CASCADE
4249SELECT COUNT(*) FROM article
4250SELECT id, array_length(regexp_split_to_array(article_content, '\s'),1) from article as t
4251SELECT COUNT(a_aid) FROM anime;
4252 UPDATE estado_impresora SET estado = 1,fecha = '"+ str(fechaUTC.fechaConFormato() + " " + fechaUTC.tiempoConFormato()) +"' WHERE idestadoimpresora = 1
4253SELECT max(fecha) FROM boletos;
4254SELECT idplaza FROM plaza WHERE nombre_plaza = '" + plz + "';
4255SELECT max(idboleto) FROM boletos;
4256UPDATE contador_tickets SET conteo = 0 WHERE idconteo = 1
4257 UPDATE estado_impresora SET estado = 1,fecha = '"+ str(fechaUTC.fechaConFormato() + " " + fechaUTC.tiempoConFormato()) +"' WHERE idestadoimpresora = 1
4258SELECT max(fecha) FROM boletos;
4259SELECT idplaza FROM plaza WHERE nombre_plaza = '" + plz + "';
4260SELECT max(idboleto) FROM boletos;
4261UPDATE contador_tickets SET conteo = 0 WHERE idconteo = 1
4262 UPDATE estado_impresora SET estado = 1,fecha = '"+ str(fechaUTC.fechaConFormato() + " " + fechaUTC.tiempoConFormato()) +"' WHERE idestadoimpresora = 1
4263SELECT max(fecha) FROM boletos;
4264SELECT idplaza FROM plaza WHERE nombre_plaza = '" + plz + "';
4265SELECT max(idboleto) FROM boletos;
4266UPDATE contador_tickets SET conteo = 0 WHERE idconteo = 1
4267SELECT ID, UserID from USERS
4268SELECT ID, UserID from USERS
4269SELECT ID, UserID from USERS
4270DELETE from USERS where ID = " + str(id_) + ";
4271SELECT ID, Name, UserID, Messages, Credits, Choice, Level from USERS
4272SELECT ID, UserID, Messages from USERS
4273SELECT ID, UserID, Credits from USERS
4274SELECT ID, UserID, DateOfLastCredit, Credits from USERS
4275SELECT ID, UserID, DateOfLastCredit from USERS
4276SELECT ID, UserID, Name from USERS
4277SELECT UserID, Level from USERS
4278SELECT UserID, Credits from USERS
4279SELECT UserID, Messages from USERS
4280SELECT UserID, Choice from USERS
4281SELECT UserID, Messages from USERS
4282SELECT UserID, Messages from USERS
4283SELECT ID, UserID, Level, Messages from USERS
4284SELECT ID, UserID, Credits, Choice, bought from USERS
4285SELECT ID, UserID, bought from USERS
4286SELECT ID, UserID from USERS
4287SELECT ID, UserID, subscribed from USERS
4288SELECT ID, UserID, subscribed from USERS
4289SELECT %s AS foo", (decimal.Decimal("19.10
4290SELECT %s AS foo", (decimal.Decimal("NaN
4291SELECT %s AS foo", (decimal.Decimal("infinity
4292SELECT %s AS foo", (decimal.Decimal("-infinity
4293SELECT %s AS foo", (float("nan
4294select 'inf'::float
4295SELECT %s AS foo", (float("inf
4296SELECT %s AS foo", (float("-inf
4297create table array_test (id integer, col timestamp without time zone[])
4298select col from array_test where id = 1
4299select col from array_test where id = 2
4300SELECT '{}' AS foo
4301SELECT '{}'::text[] AS foo
4302SELECT '{}'::text AS foo
4303select '{1,2,3}'::int4[]
4304select array['a','b','''']::text[]
4305select '{1,2,3}'::int4[]
4306select '{1,2,NULL}'::int4[]
4307SELECT %s AS foo", (decimal.Decimal("19.10
4308SELECT %s AS foo", (decimal.Decimal("NaN
4309SELECT %s AS foo", (decimal.Decimal("infinity
4310SELECT %s AS foo", (decimal.Decimal("-infinity
4311SELECT %s AS foo", (float("nan
4312select 'inf'::float
4313SELECT %s AS foo", (float("inf
4314SELECT %s AS foo", (float("-inf
4315create table array_test (id integer, col timestamp without time zone[])
4316select col from array_test where id = 1
4317select col from array_test where id = 2
4318SELECT '{}' AS foo
4319SELECT '{}'::text[] AS foo
4320SELECT '{}'::text AS foo
4321select '{1,2,3}'::int4[]
4322select array['a','b','''']::text[]
4323select '{1,2,3}'::int4[]
4324select '{1,2,NULL}'::int4[]