public.swh_visit_get.sql
No OneTemporary
Actions

Size

738 B

Subscribers

None

public.swh_visit_get.sql
View Options

	--
	-- PostgreSQL database dump
	--

	-- Dumped from database version 10.1
	-- Dumped by pg_dump version 10.2 (Debian 10.2-1.pgdg+1)

	SET statement_timeout = 0;
	SET lock_timeout = 0;
	SET idle_in_transaction_session_timeout = 0;
	SET client_encoding = 'UTF8';
	SET standard_conforming_strings = on;
	SET check_function_bodies = false;
	SET client_min_messages = warning;
	SET row_security = off;

	SET search_path = public, pg_catalog;

	--
	-- Name: swh_visit_get(bigint); Type: FUNCTION; Schema: public; Owner: -
	--

	CREATE FUNCTION swh_visit_get(origin bigint) RETURNS origin_visit
	LANGUAGE sql STABLE
	AS $$
	select *
	from origin_visit
	where origin=origin
	order by date desc
	$$;


	--
	-- PostgreSQL database dump complete
	--