File:RECURSIVE (43321721355).jpg

From Wikimedia Commons, the free media repository
Jump to navigation Jump to search

Original file ‎(1,175 × 1,500 pixels, file size: 1.22 MB, MIME type: image/jpeg)

Captions

Captions

Add a one-line explanation of what this file represents

Summary

[edit]
Description

Recurcive CTEs (Common Table Expressions) are a powerful construct within PostgreSQL, it defined in the WITH clause. CTEs allows to work with temporary set of data and transform it. In our case query collects all rags except hat from the girl, and combines it one set without duplicates :) "" is not equal operator "array_agg" conctatinates input values into array "dictinct" removes duplicates values

I've made an example to play with CTEs <a href="http://sqlfiddle.com/#!17/f2ea4c/1" rel="noreferrer nofollow">sqlfiddle.com/#!17/f2ea4c/1</a>
Date
Source RECURSIVE
Author Exey Panteleev from Moscow, Russia
Camera location55° 52′ 33.58″ N, 37° 32′ 08.9″ E Kartographer map based on OpenStreetMap.View this and other nearby images on: OpenStreetMapinfo

Licensing

[edit]
w:en:Creative Commons
attribution
This file is licensed under the Creative Commons Attribution 2.0 Generic license.
You are free:
  • to share – to copy, distribute and transmit the work
  • to remix – to adapt the work
Under the following conditions:
  • attribution – You must give appropriate credit, provide a link to the license, and indicate if changes were made. You may do so in any reasonable manner, but not in any way that suggests the licensor endorses you or your use.
This image was originally posted to Flickr by Exey Panteleev at https://flickr.com/photos/79275080@N00/43321721355 (archive). It was reviewed on 17 May 2019 by FlickreviewR 2 and was confirmed to be licensed under the terms of the cc-by-2.0.

17 May 2019

File history

Click on a date/time to view the file as it appeared at that time.

Date/TimeThumbnailDimensionsUserComment
current22:23, 17 May 2019Thumbnail for version as of 22:23, 17 May 20191,175 × 1,500 (1.22 MB)Piotr Bart (talk | contribs)Transferred from Flickr via #flickr2commons

You cannot overwrite this file.

There are no pages that use this file.

Metadata

This file contains additional information such as Exif metadata which may have been added by the digital camera, scanner, or software program used to create or digitize it. If the file has been modified from its original state, some details such as the timestamp may not fully reflect those of the original file. The timestamp is only as accurate as the clock in the camera, and it may be completely wrong.

Retrieved from "https://commons.wikimedia.org/w/index.php?title=File:RECURSIVE_(43321721355).jpg&oldid=770909152"